Results 1 to 8 of 8

Tab Creation

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    18

    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.
    Attached Files Attached Files
    Last edited by shugg24; 08-13-2010 at 09:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1