Hi,

I'm receiving live streaming data from a data supplier in the form of a DDE link.
I have 700 rows of data with 10 columns per row.

I need to copy this into another sheet as fast as possible (ideally every few seconds).
The second sheet will be copied into a third sheet (with data summarised) periodically and then cleared down.

What criteria will affect the frequency of data capture? I am pretty new to using Excel