StephenSLR
Registered User.
- Local time
- Tomorrow, 02:53
- Joined
- Oct 25, 2005
- Messages
- 48
Hello,
I would like a cell, A1 say, to always show the value of the cell directly below.
i.e. typing '=A2' in cell A1.
If a new row is inserted below row 1, I still wish A1 to show the value of the values I will enter into A2.
I have tried both absolute and relative references but when I insert a new row below row 1 the value in A1 changes to A3.
Also when I set A1 to equal A2 and I type in a date in the cell below a numerical value appears instead of the date, how do I correct this?
s
I would like a cell, A1 say, to always show the value of the cell directly below.
i.e. typing '=A2' in cell A1.
If a new row is inserted below row 1, I still wish A1 to show the value of the values I will enter into A2.
I have tried both absolute and relative references but when I insert a new row below row 1 the value in A1 changes to A3.
Also when I set A1 to equal A2 and I type in a date in the cell below a numerical value appears instead of the date, how do I correct this?
s