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,
Bookmarks