"Linda Broyles" wrote in message
...
I have a sheet in which one cell refers to cell in 2nd sheet. Can I write
the formula in such a way that even if the cell in the 2nd sheet moves
with a
sort, the cell in the 1st sheet will follow that change and still pick up
the
right information?

Ex:
Sheet 1: C2 starts out =Sheet2!E2754

Then someone sorts Sheet 2 so E2754 is now E415.

So, what I want is that when that sort happens Sheet 1 changes C2 to
=Sheet2!E415.

Make sense?

Thanks so much!

What defines this as the "right information"? If you can explain this, maybe
someone can help with a formula.