The macro collects data from all sheets in an active book, creates a new sheet and writes all data to the new sheet.
If the book is saved in .xls format, then the data will be written to new book.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.
To install you need to download lastest release
MSVBA-SheetConcat
Look at the top of your Excel Window and check Ribbon menu for button “Developer”. If you see it in the menu options, then you are ready to go and you can skip straight ahead to the next step. However, if the Developer menu is not there, just follow these instructions.
File -> Options -> Customize Ribbon
A new window will open, ensure the Developer option is ticked in the box in right side of view. Click OK.
Find the Visual Basic Editor within the Developer Ribbon Menu
Open System Folder with downloaded files, extract archive to some folder in your PC. Then select extracted files and drag and drop into VBA file tree. You can see example below.
That's all, now you can use the macro.
To run added Macro go:
Ribbon Menu -> Developer -> Code -> Macros
Select Macro "SheetConcat" and click Run.
Very welcome, but please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.
We use SemVer for versioning. For the versions available, see the tags on this repository.
- Anton Malofeev - Initial work - Arenukvern
- Mihail Melnikov - Maintainer - mixev
This project is licensed under the MIT License - see the LICENSE.md file for details
- You can be the first to whom we will be grateful😊