I have a workbook where in sheet 1 the user can select from a dropdown list. Data is pulled from sheet 2 and populates cells in sheet 1.
I then have a short macro that does the following:
Copies sheet 1
opens new workbook
saves to file using filepath detailed in cell H1
Deletes contents of cell H1
replaces formulas with values.
The user can then select the next item in the dropdown list and run the macro again.
Is there a way that the macro when run would select the next item in the dropdown and repeat the copy, save workbook process until all the items in the dropdown have been done?