Hi,
I need to merge to Macros to work with each other.
The first Macro grabs names in a cell range then makes new tab names with the names in those cells -
The other macro copies a sheet and all its data into a new sheet -![]()
Please Login or Register to view this content.
I need the macro to make a new sheet according to the names in the cell range, and copy into each of the new tab the data from sheet "Invoice", so one month i may have 8 names, then the next month may have 16 names.![]()
Please Login or Register to view this content.
so for example if there is 8 cells to be made into 8 named tabs, then each of the 8 newly made tabs will have the same data from the sheet "Invoice"
if there are 16 cells to be made into 16 named tabs, then each of the 16 newly made tabs will have the same data from the sheet "Invoice"
Thank You in advance
Bookmarks