Create multiple copies of excel based on a single template

Solved/Closed
daher - Apr 21, 2021 at 06:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 4, 2021 at 11:13 AM
Hello there,

I need your help.

I need to create multiple excel workbooks using a single template and saving them based on a list of names which is on another excel.

I also want the template to reflect the respective name in one of the cell (say in cell A2).

Can this be done using macro?

Thank you in advance.



System Configuration: Windows / Chrome 89.0.4389.90

6 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 22, 2021 at 12:04 PM
Hi Daher,

Yes.

So you want to loop through a column of names. For each name you want to make copy of your template workbook and rename it to the respective name. Place that respective name in A2 as well.

Do all the workbooks go in the same folder?
Does your template have 1 sheet?

Assuming your template workbook only has 1 sheet, then may I ask why you want to create separate workbooks? It is more convenient to have multiple sheets in a single workbook.

Best regards,
Trowa
0