Hello
I have a cell in Excel that is a DDE link, it updates fine

I wanted to keep a record of this value at the end of every minute in a list in the same worksheet of 360 records
But the list needs to remain constant at 360, so one record would drop off the top as a new one is added on to the bottom as each minute ends
Each record would move one down the list each minute
(Hope that makes sense)

Is this possible as a macro, and can anyone offer any help in terms of creating this

Charlie