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
Bookmarks