Hi,
I have excel workbook that has 6 worksheets. and these sheets (tabs) are dynamic that can be changed if I change a specific cell (this cell has all several locations). Since I have more than 60 locations, I need a macro that can:
- Build presentations for each location whenever I change the location
- Save the file into PDF file.
- AND whenever this macro finishes one location, then another macro to delete all the slides and be ready to build the other slides of the location that I'll choose from the excel file.
Anyone can help me with that? I can also share more details of the current macros that I have.
Thank you!
Z
I have excel workbook that has 6 worksheets. and these sheets (tabs) are dynamic that can be changed if I change a specific cell (this cell has all several locations). Since I have more than 60 locations, I need a macro that can:
- Build presentations for each location whenever I change the location
- Save the file into PDF file.
- AND whenever this macro finishes one location, then another macro to delete all the slides and be ready to build the other slides of the location that I'll choose from the excel file.
Anyone can help me with that? I can also share more details of the current macros that I have.
Thank you!
Z