+ Reply to Thread
Results 1 to 6 of 6

Automatically name worksheet tabs from a list

  1. 07-07-2009, 12:55 PM #1
    naeno
    naeno is offline
    Registered User
    Join Date
    11-26-2008
    Location
    Savannah, Ga
    Posts
    7

    Automatically name worksheet tabs from a list

    Is there any way to automatically name worksheet tabs from a list? I'm guessing it has something to do with a macro, but I have never run a macro before. I'm using Excel 2004 for mac. Thanks!
    Reply With QuoteRegister To Reply
  2. 07-07-2009, 01:38 PM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Automatically name worksheet tabs from a list

    See similar thread from earlier today: http://www.excelforum.com/excel-2007...-of-cells.html
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 07-07-2009, 01:50 PM #3
    naeno
    naeno is offline
    Registered User
    Join Date
    11-26-2008
    Location
    Savannah, Ga
    Posts
    7

    Re: Automatically name worksheet tabs from a list

    My apologies. Thank you for the response.
    Reply With QuoteRegister To Reply
  4. 07-07-2009, 01:55 PM #4
    naeno
    naeno is offline
    Registered User
    Join Date
    11-26-2008
    Location
    Savannah, Ga
    Posts
    7

    Re: Creat worksheets and name them from a range of cells

    I'm trying to do this same thing, but unfortunately, I don't understand where I need to go to enter the code. Do I need to create a macro, do something in VB basic, or should I use REAL Basic editor? I'm using Excel 2004 for mac. Thanks.
    Last edited by naeno; 07-07-2009 at 02:02 PM.
    Reply With QuoteRegister To Reply
  5. 07-07-2009, 02:56 PM #5
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creat worksheets and name them from a range of cells

    You're VBA-challenged on a MAC, I believe.

    Post your question in full on a thread of your own describing you problem and your need, not your expected solution.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  6. 07-07-2009, 03:07 PM #6
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Creat worksheets and name them from a range of cells

    I thought VBA was available on Mac pre XL2008 but I might be wrong - I'm not a Mac User... I'll see if RomperStomper / Mike Rickson are about...

    EDIT: I have moved the posts from the other thread back to your own...
    Last edited by DonkeyOte; 07-07-2009 at 03:09 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1