I have a 4 tab workbook I need to create multiple copies of (one for each employee to use throughout the entire coming year).
I have my Data tab, Manager tab, Rep tab, and Precap tab on said workbook that appear in that order.
On the Manager tab is a cell that will have the Employee's name in it (B5:D5. Its a merged cell).
I need a macro to create a copy of this workbook for every single name starting in A2 on the Data tab,
put the same name in that cell on the Manager tab in B5:D5,
and relabel the workbook and name it whatever is in the cell next to the name on the Data tab (B2).
It needs to keep going until it comes to the end of Column A on the Data tab.
The copies also need to save as a plain old Excel Workbook.
The save path is just going to be to my desktop (C:\Users\sblackbourne\Desktop)
If it cannot be done then I will have to create 200+ workbooks manually so ANY help would be greatly appreciated!
If you have any questions let me know please!