Replicate a file multiple times, saving with different names

gzzaniol

Hi,

I'm trying to replicate a file that is being used for one entity for multiple entities.

One of the sheets has a column with 35x rows for each entity. How can I loop through that sheet (or a list), but replicate the whole file for each of the names on that sheet/list.

My old VBA brain says something along the lines of: for i = 1 to 49, duplicate whole file, save as i.xlsx. Is it something easy to put together?!

Thanks in advance.

Maskell_Rascal

Hi @gzzaniol 

Here is a mockup of how you can do it. 

I'm reading in the file I want to duplicate with the Directory Tool, Appending the list of file names to the set, generating the Script to be run, and the using the Run Command tool. 

Here is how I have my folders setup:

When ran successfully, this mockup will duplicate and rename the file 10 times in the Output Folder. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Multi Excel Copy-Paste from Template.yxzp