200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have a spreadsheet consisting of one column and ten rows. The spreadsheet also has a cell containing a timer in the format hh:mm:ss.
The values in the single column are updated 'live' over a 30 minute period.
My problem is I would like to automatically 'Lock/Freeze' the values in the column at a certain time (e.g after 10 minutes ) during the 30 minute period they are being updated.
I would appreciate any help on how to do this
All of this depends on how the data is being updated.
If you just want the data to "freeze" in place, then you need to edit whatever is causig the data to update in the first place, such as a macro.
However, if you just want to copy the data to another worksheet or part of the same worksheet after 10 minutes, then you need a small macro to copy that data after the prescribed time.
Here is a sample macro that will copy values from row A1:A10 to C1:C10 after 10 minutes
Sub timer()
Application.OnTime Now + TimeValue("00:10:00"), "copy_code"
End Sub
Sub copy_code()
Range("A1:A10").Copy
Range("C1:C10").PasteSpecial
Application.CutCopyMode = False
Range("A1").Select
End SubYou can read more about this macro at our tutorial on running a macro so long after a workbook has been opened.
To run this specific macro, just run the timer module.