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

It can't be done.

--

Vasant






"KGray" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.