Capture Value from a Cell only once at a specific hour.

[EeHh]

Hello Seniors,

I am looking to create a workbook as below:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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

Sheet 2: Takes data from Sheet 1 and calculates values.

Sheet 3:
B1 uses VLOOKUP function to pull data from Sheet 2.
C1 takes value from B1 and uses ROUND function to calculate new value.

Sample file attached with above incorporated.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Requirement:

Sheet 3, Cell D1 copies value from C1 only once at a specific time say at 10:00 Hours.

After 10:00 hours D1 should not update value even if C1 value updates as a result of Sheet 1 getting auto-refreshed.

Before 10:00 Hours D1 should show Zero or No Data.

After 10:00 Hours D1 continues to show fixed value which was copied at 10:00 Hours.

In other words the value in D1 gets fixed/locked at 10:00 hours.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Posted at https://www.excelforum.com/excel-pr...from-a-cell-only-once-at-a-specific-hour.html still without any solution.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Kindly help.

Thanks,

 

[EeHh]

Posted here also https://www.mrexcel.com/forum/excel...pture-value-cell-only-once-specific-hour.html