+ Reply to Thread
Results 1 to 2 of 2

rename sheets using reference cells

Hybrid View

  1. #1
    Registered User
    Join Date
    04-29-2010
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    7

    rename sheets using reference cells

    Sorry I seem to be having some MAJOR issues right now. I can't upload the spreadsheet and I know it's the correct format (.xls) and not too big (888 KB) but it won't work. I can't even seem to figure out how to remove this post now. Even my emails to the webmaster are being returned "Undeliverable"

    Hi all,
    I have a spreadseet that is used to track production. It has one page for each work day of the month. On the first sheet an employee inputs their name and the day of the month and the spreadsheet automatically fills in the employees name and the work day for the remainder of the sheets. The problem is that when the next month comes around I then need to change the title of approximately 22 sheets. I would like to know if there is a way to have the sheets renamed based on the value of a cell(C2). I have seen similar codes but the date format is M/D/YY and you can't have the "/" in the name of a sheet. I have attached the spreadsheet i'm working with. If you need any further information, please let me know. Any assistance is appreciated.
    Last edited by Joshua@work; 09-28-2010 at 03:52 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: rename sheets using reference cells

    Try zipping the file.
    _________________
    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 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