Function for sheets

**Peter Niklas** · 05-31-2021, 06:53 AM

Hello,

See attached for an illustrative example of what I want to do.

So I have this excel where I copy in a list of names. The number of names varies every time and is between 1-10 names.

After I copy in the list of names in the Dashboard I have to create a copy of the "Template" sheet for every name and rename that specific sheet with the specific name.

In my excel I have a list of 5 names. Is it possible somehow to automate this process? In other words, after I have copied in the list of names in the dashboard that automatically 5 sheets are made with the same formulas as the "Template" tab that are renamed with the names in the list?

Kind Regards,

Peter

**KOKOSEK** · 05-31-2021, 08:11 AM

Use this VBA code:

Please Login or Register  to view this content.

after pasting/input name in col. A on Dashboard, run this macro.

p.s. there is no check that particular sheet exist or not, so in case if sheet NAME1 exist and you put the same name again it gives error.

**Greg M** · 05-31-2021, 08:19 AM

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.

You may enter up to ten names in the green cells on the "Dashboard" worksheet.

Hope this helps - please let me know how you get on.

Regards,

Greg M