+ Reply to Thread
Results 1 to 4 of 4

Update to week of X every week and clear cells

  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.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Update to week of X every week and clear cells

    With VBA is possible, what you want.

    I can't help you enough with that.

    You will get better help if you post an example Excel workbook (without confidential information).

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

    Re: Update to week of X every week and clear cells

    Added worksheet to beginning of post....in a really weird spot. Sorry!

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

    Re: Update to week of X every week and clear cells

    Bump for any help?

+ 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