Hi,
I have a master file which has a dropdown list (cell A12 below) and I would like the macro to loop through all the items in the list one by one. After each selection, I need to refresh/retrieve data with F9, then create a new file, copy/paste the refreshed data into the new file and then return to the master file. And keep looping through the items in the drop down list until the last one. The names of the files that are created (Book4 below) could be the item name in the dropdown list (read it from cell A12). Here is the macro that I recorded, so it reflects pretty much what I am looking for. The only thing that I need is to put it into a loop that reads all the items from the dropdown list.
Any help is much appreciated.
Cristian.
I have a master file which has a dropdown list (cell A12 below) and I would like the macro to loop through all the items in the list one by one. After each selection, I need to refresh/retrieve data with F9, then create a new file, copy/paste the refreshed data into the new file and then return to the master file. And keep looping through the items in the drop down list until the last one. The names of the files that are created (Book4 below) could be the item name in the dropdown list (read it from cell A12). Here is the macro that I recorded, so it reflects pretty much what I am looking for. The only thing that I need is to put it into a loop that reads all the items from the dropdown list.
Any help is much appreciated.
Cristian.