Sorting issue
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!
|