Find next Empty Cell in a Column and Paste Data

[thunderfoot]

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.

 

[venkat1926]

dim x as range
set x=range("a40")

first set copy to range("a40")
subsequent each set copy to
range("a40").end(xldown).offset(1,0)

you can write a macro forthis.