+ Reply to Thread
Results 1 to 3 of 3

Naming worksheets with values from cells

  1. #1
    Registered User
    Join Date
    07-12-2006
    Location
    Ohio
    MS-Off Ver
    Newest
    Posts
    49

    Naming worksheets with values from cells

    I have a large list of ID numbers in a column and need to create a tab for each value in the list. I'm guessing I need a script to do this but I'm not sure. The names dont need yo be live. They initial list can be deleted once the tabs are made. I couldnt find similar threads via search but describing this goal doeant seem acute. Any help would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Naming worksheets with values from cells

    hi look at such code
    Please Login or Register  to view this content.
    two things:
    1. the values in range A1:a10 should be unique
    2. cells of this range should not be empty
    Last edited by tom1977; 06-20-2012 at 02:41 PM.
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  3. #3
    Registered User
    Join Date
    07-12-2006
    Location
    Ohio
    MS-Off Ver
    Newest
    Posts
    49

    Re: Naming worksheets with values from cells

    Thanks Tom!

+ Reply to Thread

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