Hi Folks,

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

pastes

saves to file using filepath detailed in cell H1

Deletes contents of cell H1

replaces formulas with values.

Saves workbook

closes workbook.

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?

Thanks,

Dec