Hi, I hope someone can point me in the right direction, sorry if this is more Macro/VBA territory and in the wrong part of the forum.

I have two values, A and B, being updated using DDE. The DDE updates the value around once per second but the actual values only change about once per minute.

DDE variable 'A' is an index value (1,2,3,4,5,6, etc..)
DDE variable 'B' is the data value (2.0, 1.3, 6.7, 34.5, 100, etc..)

We would like to record the history of the DDE value, updating the list of values each time a new DDE Index value is seen.

In my current setup I have rows of equations which use these data values, all the rows are essentially the same but there is different line for each set of DDE supplied values.
in an attempt to apply the DDE values to my rows of equations, I currently use an IF statment to compare the DDE Index value with each row's Index, when they match it makes the cell value equal to the DDE value.
This partly works but as soon as the index value increments, the IF statement is no longer true and I get the default False value again.

Basically I want to hold on to DDE values the first time the If statment goes true. When it subsequently goes false, I still have those values saved.
OR Alternatively,
Is there a method to copy the DDE data value to a new cell, automatically indexing the cells location each time. Thus giving me the history of the DDE values as required.
I did try a few of my own clunky macros but with them constantly running it made any other work on the sheet impossible.
any thoughts ?
Cheers,
J.