how to write in a cell every time another one changes

[marinerdrums]

Hi,
in my calc sheet, some data are imported and automatically updated by an external link table.
They are currencies data.

How can I create the history of the data changes?

• Let say for instance the cell B2 is updated in real time by the external link table connection
• I would need to copy the B2 content in the cell C2
• then when B2 changes again to copy the new value in C3 and so on… to create an history of the variations and consequently draw a graphic line.

Thank for your help.

[Lupp]

-1- Spreadsheets are basically not history aware. To add the feature you need user code.
-2- Long ago I suggested some workarounds based on misused “iterations” with formulae. I withdrew these suggestions because of their lack in reliability.
-3- Can you actually afford a complete column for the history of one cell?

[marinerdrums]

Thank for the answer Lupp,
my calc file is actually very very little, I do have few field used and I would need to keep track of one value only which is the evolution of a percentage through the days.
So I do not know if your question was rethorical or real… in the second case I would say yes, of course, the calc sheet is pretty empty.