Excel In Excel how can I block the contenent of a cell?


Joined
Dec 13, 2016
Messages
3
Reaction score
0
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 ?
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top