text substitution
So, you have 2 cells in the same line showing the same info so you can
always see one since they are far apart? Is that correct?
Why not just choose one to always be the one with the location typed
in. The other one is just "=A1", or whatever cell reference you need.
|