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

D

Daniele

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:

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

Similar Threads

Excel In Excel how can I save a value on daily basis 2
Excel Need Countifs Formula Help 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Help to copy information from one row at a time to another sheet 1
Excel Copy COUNTIF while retaining reference 7
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Excel Linking Multiple cells to One cell for Results 0

Top