Im importing data into Excel at various times. (Every ½ hour)
When the data initially populates the appropriate cells a formula
calculates a specific value.

As soon as the next time interval occurs the data re-populates and
over-writes the same cells and the formula re-calculates the value.

Is there any way to automatically reference and save the initial
calculated value prior to the next data import for comparison
purposes?

Right now Im doing it manually with the Copy/Paste Special/Value.

You could have subsequent imports populate below the 1st import,
perhaps, in the next empty row!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion