Hello,
I have a list of Counties in column A with their region listed in column B. (see attached example file).
All 17 files are structured the same, so when I change anything, I need to change all 17 files.
When I update my master file, I save it, but then I want to make 17 file copies of it as per below.
Update cell F1 to the name of the first county in column A.
Update cell F3 to the name of the first region in column B.
Then save the file with the save name being the first county name in column A.
Update the cell F1 to the name of the second county in column A.
Update cell F3 to the name of the second region in column B.
Then save the file with the save name being the second county name in column A.
And so on, looping through the whole list in column A and B.
So its a looping save macro that I require if you can help.
Thanks very much.
Bookmarks