+ Reply to Thread
Results 1 to 7 of 7

Automatic Date Update/Change

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Automatic Date Update/Change

    Hello all,

    I am struggling with a task that I would like to Excel to perform, which is to automatically update the date to the current date in cell A1 when the numerical value in B1 changes.

    Any suggestions on how I could accomplish the above would be greatly appreciated!

    Thank you very much in advance!

    Chris

  2. #2
    Registered User
    Join Date
    07-12-2012
    Location
    New Hampshire, United States
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Automatic Date Update/Change

    Do you mean something like this?

    Please Login or Register  to view this content.
    Put it in your "Sheet1" object.

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Automatic Date Update/Change

    hi carrob...that's exactly what i am looking for...and it's so less complicated than what i was trying to do...thank you very much!!!

  4. #4
    Registered User
    Join Date
    07-12-2012
    Location
    New Hampshire, United States
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Automatic Date Update/Change

    You're welcome, glad it works for you. Don't forget to mark the thread as solved. To do this click Thread Tools above and click mark as solved. Also, I would appreciate it if you could click the star in the bottom left of my post to thank me as well.

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Automatic Date Update/Change

    ...actually, I have another question. I would like to have the dates update over a range. So, my dates are in cells A1 to A10 and I have numerical values that update in corresponding cells C1 to C10. I have tried figuring it out with what you had sent me earlier; however, no luck. What is it that I am missing?

  6. #6
    Registered User
    Join Date
    07-12-2012
    Location
    New Hampshire, United States
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Automatic Date Update/Change

    So do you mean you will be inputting values into column C and want A to be updated or are you still inputting in column B but A and C will be updated?

    ---------- Post added at 02:53 PM ---------- Previous post was at 02:48 PM ----------

    This is if you are still inputting into column B and want values in A and C to update:
    Please Login or Register  to view this content.
    This is if you are inputting in column C and want A to update with the date:
    Please Login or Register  to view this content.
    let me know if that works for you.

  7. #7
    Registered User
    Join Date
    07-25-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Automatic Date Update/Change

    Thanks so much!!

+ 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