Track the changes of a cell value

[Marco Cisamolo]

Hi,

I have an excel problem. I would like to track the changes of a cell value connected to another sheet. With reference to the uploaded excel:

• Initially cells B2 and B7 are equal;
• Once I change a value in the secondary sheet, B7 changes. I copy paste the value in cell B3;
• I keep doing the process until I ultimate the changes.

I would like to know if there is a possibility to avoid all this process.
I tried to keep the thread as open as possible as I am open to alternative solutions.

Thanks for your time and attention.

Marco

 

[vletm]

@Marco Cisamolo
One sample idea ...