View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joni joni is offline
external usenet poster
 
Posts: 1
Default how to roll/scroll/log (??) real-time data ?

In cell A1 I have a DDE-link to a real-time data source.
Works fine, however instead of having this one cell
update each time the value changes, I'd like to "log"
(roll? scroll? I don't know how to call this) the
previous data to cell A2 etc., in time building column A
with all past values that occurred.
Stock market programs do this effortlessly (like when
building "time and sales" sheets) but I just cannot
figure it out. Should be some standard command I'd say,
or does this require high-end programming? Thanks!!