I’m 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 I’m doing it manually with the Copy/Paste Special/Value.