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,

Please Login or Register  to view this content.

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