I have a macro (that I have attached) that currently does 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 the end result is that I have a workbook saved for every line in column A.
However, I need to make the following change and I am not sure how to go about it:
I added some information in Columns C and E of "Sheet1". I need all of the C column data to go to "Input" "C2" and all of the E column data to go to "Input" "E5".
So for example, in the first workbook copy the "Input sheet should read: "15-14-16" in "A1" and "John" in "C2" and "AZ" in “E5" and the second workbook copy should read: “18-19-21 in “A1” Steven in “C2” and “AZ” in “E5”.
Does anyone know how to help me with this?
Thanks a ton
Bookmarks