VBA - Create Multiple Copies of Tab & Rename Each

[NaityP]

Hello,

I have a list of 122 Job #'s located here: 'Lists'!D3:D124 (no header).

I have created a template tab named after the first job # in the list ('1000-9900') and filled it with references, formulas, formatting, etc.

Is there a macro I can use that will create a copy of this tab for each job number in my list (renaming each tab automatically) so that I do not have to manually rename each tab?

Thank you,

NaityP

 

[NaityP]

Please disregard. I continued searching and found the answer here: http://www.mrexcel.com/forum/excel-questions/973987-macro-copy-sheet-rename-list-skip-duplicate.html

Hello,

I have a list of 122 Job #'s located here: 'Lists'!D3:D124 (no header).

I have created a template tab named after the first job # in the list ('1000-9900') and filled it with references, formulas, formatting, etc.

Is there a macro I can use that will create a copy of this tab for each job number in my list (renaming each tab automatically) so that I do not have to manually rename each tab?

Thank you,

NaityP