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