In my spreadsheet, I need to take sort of snapshots from time to time, eg write a formula =A1+A2+A3.
What I’d want to do is copy current value of cells A1…A3, and not update the result of a snapshot when the values for A1…A3 change.
Eg: today A1=1 A2=2 A3=3
I want a snapshot cell B1 to have =A1+A2+A3, displaying 6.
Tomorrow values change to
A1=2 A2=4 A3=6. I’d want the previous snapshot cell B1 to keep old value (6), and new snapshot cell B2 to have =A1+A2+A3, displaying 12.
Same the day after when the values change again, B1 and B2 keep their old values, etc etc.
Is it possible to do? Currently, I have to manually copy values for cells A1..A3, but I was hoping for an automated solution.
