New to VBA so would appreciate help on a particular Macro I'm trying to set up.
i have a worksheet which changes based on the value selected from a drop down list in a specific cell.
I want to write a macro that saves the worksheet as a PDF, selects the next value from the data validation list, repeats the save and so on until the full list of values is exhausted.
I have a SAVE PDF Macro but can't manage to add to it to get it to loop through this process for each value on the list.