History for Realtime measurement

Hello all,

I have a question about copying a value from one cell to another row.

I'm having realtime measurement coming into excel from a flowmeter.
The connection is made with DDE.

All is going well but I have only one cell that gets an update every second or so. Value in the cell is between 0.0000 and 2.0000 and depends on the flow in the flowmeter.
I want to store the information from that realtimecell to the next row to be able to create a graph.

How do I copy (automatic) that cell to a row so I can have some history from that realtime measurement?

Thanks,

David.