Greetings,
I am trying to copy several values, which are constantly changing (updated), from specific cells into other cells on the same or another sheet thereby creating a list or history. The worksheet is already updated constantly (sub second timeframe), so I do not need it updated I already have this feature. I am trying to get this recording to occur at specific intervals, every 5 seconds. I would like the data copied every 5 seconds, ALL DAY not just once a day at a specific time. Ideally it would be best to be able to plug in start and stop times. I have intermediate standard excel experience but not much experience with VBA. I have searched the threads and not found anything that addresses this specific problem. Any help or suggestions provided would be greatly appreciated. Below is code that someone had linked that is similar to what I want to accomplish but still isn't there. Thank you in advance for your time.
______________________________________________________________________________________________________________________________
'These subs must go on the ThisWorkbook code pane. They won't work at all if installed anywhere else!
______________________________________________________________________________________________________________________________
'This code must go in a regular module sheet. It will not work at all if installed anywhere else! Make sure the Public statement is above any subs or functions.
______________________________________________________________________________________________________________________________
Anthony
_________________________________________________________________________
Bookmarks