Tab Creation

I would like to program a button that creates several sheets that are copies of a template sheet, but name them based off of the cells in another seperate sheet. In this manner the copies will have the same formatting as the template sheet, but be labeled indivdually according to the sheet the names are pulled from. I have included a dummy file below that simulates my situation. In this file the "senario sheet" contains the names for the copied sheets but the letters "A" and "B" are appended before the names to specify which copy is which. The copied sheets that I want to be created are highlighted in red. When the cell labeled "button" is double clicked, two copies should be created for each senario as shown in the dummy file, one with the letter "A" in front and one with the letter "B".

Please let me know of any problems or ways in which I can be more specific.

Thank you for your help.

Right click button sheet tab and View code.

Please Login or Register  to view this content.

By the way scenario has a C in it

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Use a function to test for existence of sheet.

Please Login or Register  to view this content.