VBA Macro code to open new worksheet and save multiple versions...

[musicman1985]

Hi. My latest project has presented me with a bit of a problem (i.e. A very repetitive, time-consuming and boring task) that ideally I could automate, hopefully with a macro.

Here is the problem (the solution MAY be very simple, I just might not be able to see it!):

I'm in Workbook 1, and in sheet 1 ("January") column B&Q contains a list of names. cell A1 contains "1) January". I need a Macro to:

1) open Workbook 2
2) save a copy of Workbook 2 with the file name "B1 A1" i.e. "John Smith 1) January"
3) move to the next name (B2) and repeat until the first blank row (the end of the list of names)

So that if I have 10 names in column B, once the Macro is complete, I'll have 10
versions of Workbook 2 saved in a particular folder.

Would something like this be possible?

Thanks,
Paul

[AlphaFrog]

Change the Path and name of the source workbook and the destination path to suit.

Please Login or Register  to view this content.