Hi all
I am wondering if its possible to have a macro go down a list of employee names and save the file (multiple tabs) in a PDF format on a path on my c:drive?
Here is my request
1) "Employee" tab contains list of employees A2:A6 (my original file contains A2:A108)
-> I would like the macro to go down on by one and change the value in cell E7 on the "Summary" tab (this will update the data points on the Summary, WIP Table, AR Table)
2) Take the tabs "Summary", "WIP Table" and "AR Table" and save as "PDF" format in a single file
3) Save the files by Employee name + Current month on a path on my c:drive
All my data/formulas have been updated, so I simply need a macro that can accomplish the above? There are 107 employees in total, so there should be 107 employee PDF version files.
I have attached a sample, with just 4 employee names....can someone pls help? FYI: I would like the macro to be smart enough to execute based on the # of names listed in the "employee" tab
Thank you so much in advance!
Bookmarks