Because nobody can answer my previous question, I'm trying to make it in another way.
Today, day 1, I have cell B1 that it's copying the value from A1, tomorrow, day 2, I will update the value in cell A1 and I'd like that cell B2 will copy the value from A1, the day after tomorrow, day 3, I will update the value in cell A1 and I'd like that cell B3 will copy the value from A1 and so on, so on.
Now, if in day 2 I change the value in A1, B2 will copy that value, but B1 is changing too, and, if in day 3 I change the value in A1, B3 will copy the value, but B1 and B2 are changing too and so on
How can I stop B1 and B2 to change their previous value without do it manually ?
Today, day 1, I have cell B1 that it's copying the value from A1, tomorrow, day 2, I will update the value in cell A1 and I'd like that cell B2 will copy the value from A1, the day after tomorrow, day 3, I will update the value in cell A1 and I'd like that cell B3 will copy the value from A1 and so on, so on.
Now, if in day 2 I change the value in A1, B2 will copy that value, but B1 is changing too, and, if in day 3 I change the value in A1, B3 will copy the value, but B1 and B2 are changing too and so on
How can I stop B1 and B2 to change their previous value without do it manually ?
Last edited: