MACRO - Paste value and then save file multiple times ---- please help

I have a list of about 30 values in Column A on Sheet1. When I click on a button, I need to have a macro that will do 2 things:
1) Paste the value of that cell in another cell on sheet2 (Pasted in cell D7)
2) then save the file in a folder on my hard drive with the YYMM and then the value that was clicked on (ie: 1301xxxxxxxx)

I need this process to loop through all 30 values in Column A on Sheet1.


I am hoping someone can assist me with this macro. It is urgent. (Uggghh)

Thanks in advance. I am hoping that this is quick and easy for someone out there.

Something like this:

Please Login or Register  to view this content.