how do I format a cell reference to move as source changes
 

In Excel - how do I format a reference cell so that the reference changes as
the source cell changes. example: Source cell on one worksheet; reference
cell on a linked worksheet. If I resort the worksheet and the source cell
moves, the reference is not moving with it. The reference cell remains
linked to the first cell on the source sheet. I have used both formats of
anchoring with a $ and using nothing. Help.

It can't be done.

--

Vasant






"KGray" wrote in message
...
In Excel - how do I format a reference cell so that the reference changes
as
the source cell changes. example: Source cell on one worksheet;
reference
cell on a linked worksheet. If I resort the worksheet and the source cell
moves, the reference is not moving with it. The reference cell remains
linked to the first cell on the source sheet. I have used both formats of
anchoring with a $ and using nothing. Help.