Create new worksheest based on a list of names & Template

[Barking_Mad]

Hi,

I have some code that creates and renames new worksheets based on a list of cells in another sheet (Summary) . What i would also like is to have these new sheets to contain the information based in another worksheet called 'Template' rather than just being blank sheets. I've faffed around but can't seem to get it to do it properly. Help appreciated....

Please Login or Register  to view this content.

[Subverter]

What about using copy instead of "Add", like this:

Please Login or Register  to view this content.

Make sure that range("A1:A10") of sheet "Summary" is full of data.

[Barking_Mad]

Hi,

That creates the sheets but doesn't rename them as per the list. They are just called 'Template 1, Template 2 etc....

[Subverter]

Try this Example...
Examp.xlsm

idk if there's a difference between executing it in Excel 2010..

[Barking_Mad]

thanks that works fine. Is there any way the code can be changed so that I dont have to enter the range (A1:A10) in the macro itself and it just finds where the test in the column finishes automatically?