Copy "Template" worksheet, Paste, and Rename -then add more ws's as customer list changes.

[vcuphysics]

I am working with a Workbook that contains a Template worksheet and a CustomerMaster worksheet. I use the script below to make a copy of the Template, and rename the copied template based on Column A of the CustomerMaster worksheet. The Customer Information changes from time to time on CustomerMaster (Customers are added to the list but never removed). My challenge is this. I need to create worksheets for each newly added customer, without modifying the already copied and renamed worksheets produced by running the VBA previously. So I would like to modify my VBA script to only create a template worksheet for newly added Customers only in Column A of CustomerMaster.

Please Login or Register  to view this content.

Please help!

Thanks,

Adam

[arlu1201]

Try this

Please Login or Register  to view this content.

[vcuphysics]

I've plugged your solution in and I get the following error message after it creates one new sheet.

"Run-time Error: 13"

Type Mismatch

Thanks for your quick response!

[arlu1201]

Oops, i think i got it. Try this

Please Login or Register  to view this content.

[vcuphysics]

That worked perfectly!

Thank you again for the quick response!

Adam