I have a cell that takes in data via DDE.

I need a function, say, like =STORE(DDE_Cell,Range) that will store the
changing data from DDE_Cell into Range one cell at a time. When all the cells
in the range are filled, the next STORE will be back to the top cell. Then,
each successive change will overwrite the previous data.

A second, similar function is, say =FIFO(DDE_Cell,Range) that will store the
data from the DDE_Cell into the first or top cell of Range. The data in each
cell of Range is also moved to the next cell in shift register fashion. The
data in the last, bottom cell will be discarded.

Then, I can create a chart from Range where I can view the data like a
recorder.

Hope, you all like this. Please, please vote for this suggestion.

Thanks,
--
Emmie Villa

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions