Copying Template to Multiple Sheets along with Renaming

Hello Excel Wizards,

I'm currently in a situation where I need to create multiple worksheets from a list that's in excel. In addition, to that there's a certain template that needs to be attached to each one of these names in the list. I'm looking for a method to create a way to not only rename the worksheet name to what's on the list but to have that particular template be included as well. I included a sample of the data that I have one tab that's called 'List" and it is column "C" that needs to have worksheets named after those and another tab called "template" which has the style of formatting and layout needed for each tab. Any help on this would be greatly appreciated!

Thanks again!

Hi Excell1677,

Please try:

Please Login or Register  to view this content.

Hope this is what you're looking for

Hi D13L!.

All I can say is WOW! This is EXACTLY what I was looking for! I just have one question is there a way have it go in order from left(first) to right(last) as opposed to the first one being the last?

Thanks Again for looking at this!

Yeah,

Just modify the For i line to:

Please Login or Register  to view this content.

Thanks again for your help D13L works perfectly!

Glad to be of help.