Hello - I need a macro that saves a sheet to PDF, then changes a cell value to the next name on a list to run the analysis for that name, then prints the sheet again to a separate PDF, and repeats until it has run through all the names. I've been looking but haven't found exactly what I'm looking for.
For example, let's say I have 2 sheets, 'Output' and 'Data'. The Data tab contains sales and other info for 10 locations. The Output pulls in data from the Data tab for whichever location name is entered into cell A1 and then runs an analysis. I need a macro that generates a PDF of the Output sheet, then changes cell A1 for the next location, recalculates, saves another PDF, and repeats until a report has been saved for each location.
Filepath: Cell A2 (Output)
Filename: Cell A3 (Output)
List of Locations: K2:K (Output)
Thank you!!
Note: I've also posted this question on Mr Excel (I didn't know this wasn't allowed, didn't know which forum was most active): Can't post link so this is the thread threads/vba-change-cell-value-to-next-in-a-list-save-sheet-as-pdf-repeat.1158600/
Bookmarks