In cell A1 type =B1
now in B1 type the number 10.
A1 looks at B1 and shows the value 10.
If I then cut the contents of B1 and Paste them into C1, A1 will still show
the value 10 and the formula has changed to =C1.
My question is how do I make 100% sure that the formula I put into cell A1
will always look at B1 regardless of cutting and pasting actions in the
target reference cell. Please note before answering putting $ in front of the
formula eg =$B$1 makes no difference the formula wil just become =$C$1. Thank
you for your assistance in advance.