+ Reply to Thread
Results 1 to 2 of 2

Auto rename sheets 1-7 with weekdays and dates

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Menomonie, Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Auto rename sheets 1-7 with weekdays and dates

    Hello everyone. I am new to VB and this forum. TIA for any assistance anyone can provide.

    I am looking for a macro/VBA code that will rename sheets 1-7 as "Sunday MMDDYY" thru "Saturday MMDDYY", respectively. Ideally, it would trigger based on the change of a single cell in sheet10. The sheet10 B1 cell contains a text date value that will be edited by the spreadsheet user at the end of each week to update dates in the sheet names and spreadsheet calculations for the next weeks information. I have everything done except the tab auto rename which I am struggling with, not knowing VB very well.

    Alternately, all A1 cells of sheet1 - sheet7 have a date but it is a referenced value from sheet10 cell B1 so the sub function I have found does not work since those cell values are not text.

    Any help would be greatly appreciated. thanks much.

  2. #2
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Auto rename sheets 1-7 with weekdays and dates

    Hi,
    welcome to the forum!
    If you have a date in every cell A1 (Sheet1 to Sheet7) then just for a test you can try it on a test file.
    add it to worksheet module
    Please Login or Register  to view this content.
    blue

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Group dates in chart by weekdays
    By jsich in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-19-2013, 07:33 AM
  2. [SOLVED] Dates wont format to weekdays
    By georgeparker88 in forum Excel General
    Replies: 3
    Last Post: 08-06-2012, 09:10 AM
  3. Dates without weekdays
    By smurray7 in forum Excel General
    Replies: 8
    Last Post: 08-24-2011, 04:26 AM
  4. Number of weekdays between 2 dates
    By certain_death in forum Excel General
    Replies: 3
    Last Post: 08-05-2008, 04:28 AM
  5. [SOLVED] How do i count number of weekdays between two dates?
    By Sanjay Shah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2005, 12:06 PM

Tags for this Thread

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