Copt Template sheet, rename sheet based on list and create hyperlink

[jimbo83]

Hi All,

First post to the forum so hello and thanks in advance for the help.

I have a template sheet in excel that I would like to replicate for a list of accounts. The list is in Column A on Sheet "Summary" and starts at A2

The template is called "Template"

I would like to copy the Template sheet for each account in the list, and have it rename the sheet with the account name.

I would also like the name to be placed in Cell B1 on each sheet it creates.

Once the sheet is created, I would like the list to link to each sheet as it creates it.

I have found a way of doing some of these steps individually but I can't seem to get them all to work together in one.

Finally is there a way to do this so that it would ignore any sheets that are already created? My thinking here is that if I add new account names to the end of the list it would be good to re run this and get the new sheets created.

[maniacb]

If you share the spreadsheet you have been working on, as per the yellow banner above, we can assist further.

[maniacb]

Try this code. If it doesn't work, you'll need to provide a sample workbook to work from.

Please Login or Register  to view this content.

[maniacb]

This version checks for existing tabs and won't duplicate them:

Please Login or Register  to view this content.