Results 1 to 2 of 2

rename sheets using reference cells

Threaded 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.

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