Macro to record a cell value at specific times
Posted on 2007-08-03
I'm looking to write a macro that records a cell's value (call this price) when a cell displaying the current time is matched against a list of times in column A.
I started by putting a list of times in column A and thought if I could write a macro that said "If cell "time" is found in column A then copy cell "price" and paste special -> values to the same row in column B, but I'm really struggling to come up with any meaningful code.
If anyone could provide any assistance, it would be very much appreciated.