Hi excel experts
I'll explain my situation. I've a workbook that contains two worksheets:
a) worksheet ("list")
b) worksheet ("template")
The worksheet ("list") has a list of names, from cell A1 to A5. For example: A1 = aa; A2=bb; A3=cc...and so on
Well, I would like to have a code that would create a new workbook, that would contain a copy of the "template", in a specific folder, named with each name present in column A (worksheet "list").
So, I would have several workbooks, all equals to the template and each one named by each name present in the column A, in the worksheet ("list").
Thank you for the help.
cheers
Bookmarks