Hi,

Cell A1 values changes dynamically throughout the day till say 1550 hours.

I am looking to capture value from a dynamic cell (A1) at a specific hour say at 1600 hours.

The captured value will be saved in a column (B) everyday with date (column A) starting from say Row10.

Not able to attach a sample sheet as the attachment window is not working. A picture is attached instead.

Thanks,


Sample 1.jpg