R
Richorton
Is there a formula that will show what the contents of another cell is.
Example
A1 =(B1)
The Value of B1 is 'Test'
Therefore the value of A1 is 'Test'
However if I were to drag Cell B1 to, lets say, C1
The formula in A1 would automatically change to =(C1) and the value would
remain 'Test'.
I want it so the formula in A1 stays as =(B1), no matter if I move the cell
Is this possible?
Many Thanks
Example
A1 =(B1)
The Value of B1 is 'Test'
Therefore the value of A1 is 'Test'
However if I were to drag Cell B1 to, lets say, C1
The formula in A1 would automatically change to =(C1) and the value would
remain 'Test'.
I want it so the formula in A1 stays as =(B1), no matter if I move the cell
Is this possible?
Many Thanks