Create a new worksheet by copying another tab with all the codes

[loneman]

Hi,

I am attempting to write a small code for the following scenario..

I have a workbook with worksheets GP1, GP2, GP3 etc & a template page as the last tab.
All the worksheets column names are same but have different data.
Last worksheet is the template for all of them. How do I create
a command button in template page... upon clicking the button,
it should create a tab just before the template worksheet incrementing
previous tab GP3 +1-> GP4. GP4 should be a copy of the template page
along with all the vb codes associated with the template page.

So tabs looks like=> GP1, GP2, GP3, GP4, template

Any sample code would be nice!

[xladept]

Hi loneman,

Perhaps:

Please Login or Register  to view this content.

[loneman]

Thank you xladept!!!! Code works except one small issue. I wanted to get the worksheet name as follows.
If the worksheets are GP1, GP2, GP3.. GP50.. etc.) & (template worksheet)... for the new worksheet name, 2 letters, GP, stays the same but the number increments to next number.. If I have the following worksheets existing:

GP1, GP2, GP3, template => the new worksheet name to be GP4 (GP & 3 +1).... right now the code gives me GP31.. how can I update the code get this outcome?

[xladept]

Sorry - try:

Please Login or Register  to view this content.

[loneman]

Thanks a million!!

[xladept]

You're welcome!