thunderfoot
Board Regular
- Joined
- May 28, 2004
- Messages
- 229
I have a table in EXCEL that is being updated from the Internet every 5 seconds or so.
The table being updated is Range A5:R15 (Named Range "DataUpdate"), and has a Timestamp within the data.
Underneath I want to copy the data from A5:R15 to a larger table (same Column Formats), Range A40:R10000, every time the data in the top table is updated, so possibly every 5 seconds.
Therefore I want a macro routine that will :-
a) Operate when the Timestamp changes.
b) Copy the data from the Top table to the next available empty cell in the Range A40:A10000 (or Column A), thus the 1st copy will be from A5:R15 to A40:R50, the next copy is from A5:R15 to A51:R61 etc. etc. etc.
c) Is easily stoppable.
The table being updated is Range A5:R15 (Named Range "DataUpdate"), and has a Timestamp within the data.
Underneath I want to copy the data from A5:R15 to a larger table (same Column Formats), Range A40:R10000, every time the data in the top table is updated, so possibly every 5 seconds.
Therefore I want a macro routine that will :-
a) Operate when the Timestamp changes.
b) Copy the data from the Top table to the next available empty cell in the Range A40:A10000 (or Column A), thus the 1st copy will be from A5:R15 to A40:R50, the next copy is from A5:R15 to A51:R61 etc. etc. etc.
c) Is easily stoppable.