I am looking for a macro that will do the following:
1. Copy a cell "A2" in "Sheet1" to "Input"cell "A4" then
2. Save the entire workbook as is to "C:\Macro" with the naming convention being: (The contents of “A4”.2013) in the "Input" sheet
3. Then repeat for every cell in Column A that has data.
So, If I have 10 rows in column A of "Sheet1" I should end up with 10 worksheets saved in the "C:\Macro" folder on my hard drive named "(contents of each cell in Column A.2013)"
I have attached a spread sheet to make it easier to visualize.
Thanks,
Bookmarks