+ Reply to Thread
Results 1 to 2 of 2

Automatic date update in a cell when another cell's value changes (as calculated

  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    chennai
    MS-Off Ver
    Excel 2016
    Posts
    48

    Automatic date update in a cell when another cell's value changes (as calculated

    Hi All,
    I need an help one excel formula or VBA codes ,i have specific
    range with prices, but when ever there is a
    change in value in the range then one particular
    need to be updated with now() formula. Find
    below the snap shot of desired data....
    Product Changes happened Jan'13 Feb'13 Mar'13
    Apr'13 May'13 Jun'13 Jul'13 Sep'13
    Apple
    Orange
    Pineapple
    Fruits
    In the above data i have values for all product in
    all months. if there is any change happened then
    in the changes happened column need to be
    updated with now() formula.
    Thanks in advance...

    Vinwin

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Automatic date update in a cell when another cell's value changes (as calculated

    Do a web search for date stamp site:excelforum.com. You will find several solutions from this forum.

+ 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