new cell with changes
 

Hello

I have a sheet which is connected via DDE, i.e. some cells get updated via
API.

I would like to analyse this data for high and low values.

How can I save this data in other cells (continuous) or print a chart
(dynamicly). Is there a funktion which adds new cells after a value has
changed?

To use =MAX() or =MIN() is not good as it is overwritten with new data.

Any ideas, links, etc. are welcome.

Daniel

Daniel,

This article explains some of the methods used to update a chart
automatically as new data is entered into a spreadsheet. If you just want to
update a range, the formulas that are illustrated will do that too.

http://pubs.logicalexpressions.com/p...cle.asp?ID=518

Hope this helps.

----
Regards,
John Mansfield
http://www.pdbook.com


"Daniel Gubser" wrote:

Hello

I have a sheet which is connected via DDE, i.e. some cells get updated via
API.

I would like to analyse this data for high and low values.

How can I save this data in other cells (continuous) or print a chart
(dynamicly). Is there a funktion which adds new cells after a value has
changed?

To use =MAX() or =MIN() is not good as it is overwritten with new data.

Any ideas, links, etc. are welcome.

Daniel