+ Reply to Thread
Results 1 to 4 of 4

Save / record dynamically changing values of a cell in a column with date time stamp

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    London
    MS-Off Ver
    2010
    Posts
    33

    Save / record dynamically changing values of a cell in a column with date time stamp

    Hi experts,

    Sheet 1: Pulls data from web say every 15 minutes.

    Sheet 3: Calculates values using a formula.

    Sheet 2: Cell D2 pulls values from Sheet 3 using Vlookup function. The values in D2 keep on changing dynamically.

    Requirement:

    Sheet 2 , Column E should record the value of D2 every time it changes.

    Sheet 2 , Column F should record the date and time stamp everytime a cell in Column E is populated.

    Sheet 2 , Column E and F will keep on growing with every update in Cell D2.

    Eg:
    D2= 25891 , E2= 25891 F2 = 20/02/2019 10:00
    D2= 25900 , E3= 25900 F3 = 20/02/2019 10:15
    D2= 25800 , E4= 25800 F4 = 20/02/2019 10:30


    Tried to use a code from https://www.extendoffice.com/documen...ng-values.html Sample file attached.

    But it works only if the values in Sheet 2 Cell D2 are changed directly and not by using a formula as in my case.

    Kindly help.

    Thanks,
    Attached Files Attached Files
    Last edited by EEEHHH; 02-20-2019 at 06:50 AM.

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    excel 2016 64bit - Windows 10
    Posts
    2,056

    Re: Save / record dynamically changing values of a cell in a column with date time stamp

    Please Login or Register  to view this content.
    Last edited by nigelog; 02-20-2019 at 07:01 AM.

  3. #3
    Registered User
    Join Date
    01-02-2018
    Location
    London
    MS-Off Ver
    2010
    Posts
    33

    Re: Save / record dynamically changing values of a cell in a column with date time stamp

    Superb.

    Thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,531

    Re: Save / record dynamically changing values of a cell in a column with date time stamp

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Time Stamp Active Cells and Record a History of Time Stamp and Active Cell Value
    By harishangaran in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-22-2017, 12:41 PM
  2. Recording time for dynamically changing cell values
    By mahe1188 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-01-2016, 06:16 PM
  3. I would like to add a date and time stamp to a cell in Excel 2010 by hitting save
    By malott3417 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2016, 12:43 PM
  4. Create button on spreadsheet when clicked record date stamp in the next column
    By HBHB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 06:52 PM
  5. Replies: 1
    Last Post: 01-12-2013, 04:14 PM
  6. [SOLVED] How to record changes to cell values including time stamp
    By bigmantitus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2012, 10:13 AM
  7. [SOLVED] Record time stamp once cell is double clicked
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-17-2012, 09:23 AM

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