Duplicating worksheets from template worksheet and rename them from a list of values

[Verioon]

Hi everyone,

I need to create a spreadsheet with 665 worksheets that are named after a list of 665 values. Those worksheets have to be duplicated from a template worksheet because they all have to have the same basic formatting and a few formulas in a table. How to automatically create worksheets named from a list of values, but I don't know how to combine that with duplicating them from a template worksheet.

The list of values is "list!A2:A666" if anyone has a template sub already.
The template worksheet is named "template"

My question is how I can combine the worksheet.copy with the naming from a list and how to loop it for 665 times.

Thanks in advance!

[Marc L]

Hi !

Should we guess for the template worksheet ?‼

See the Worksheets.Copy method in the VBA help to create a worksheet from a template worksheet …

[Marc L]

I misread a little …

So use a For Each loop from the source range like For Each V In[list!A2:A666].Value2 (there is a space after In …)
as V is a Variant Variable for each Value
then you can copy the template and rename the new worksheet according to V …

665 worksheets : I hope it's for your eyes only ! (Limit insane, how to manage so many …)

[modytrane]

See attached sample. click on the Copy button.

Hope it helps.

here's the simple macro used:

Sub duplicate()

Please Login or Register  to view this content.