Results 1 to 4 of 4

Update to week of X every week and clear cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    28

    Update to week of X every week and clear cells

    Employee Work Sheet.xlsxHi newbie question here,

    In my spreadsheet I manually type what week it is being used for. This week I typed:

    "For the week of 6/4/2012 - 6/8/2012"

    Is there a way to make it so that when I load up the spreadsheet next week (6/11), it will automatically change it to show:

    "For the week of 6/11/2012 - 6/15/2012".

    What would be even one step cooler, would be if it could clear out all of the cells that had information in them for each week too.
    I.E. it keeps the base template and removes all of the inputted values from the previous week.

    Thanks for any help if possible, Adam
    Last edited by adamsurpren; 06-08-2012 at 11:41 AM.

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