Select, Update, Save As

[AMayland]

I have a Data Validation in Cell A6 (200 Values)

I also have a Button that Refreshes all my power queries in the workbook that I press after I select the value from A6 in the drop-down.

I then save the file as that value in A6.


Is it possible to run a VBA to loop this process and save off the file each time for all 200 Values?


Thanks

[akhileshgs]

Wont it be easier to record the macro?

[AMayland]

I guess maybe I have an easier way to do it.

I have a folder of these 200 files already created. I need it to either do it the way above or access the folder, and run through the already created files and just click the button (with my VBA tied in) and re-save the file. Is that easily recordable? It needs to be updated monthly.