Shane is right... My suggestion would work only if you sort the cells
containing the INDIRECT formula...

So do test before making big changes...

Let us agree on what you want before trying to find an easier way to do it.

"Shane Devenshire" wrote:

Hi,

Unless I missunderstand the use of INDIRECT does not do what you need. You
should test it with a few cells before you spend the time modifying all the
cells. If I understand, you want to sort raw data and other sheets that are
linked to that raw data you want to refer to the new location of the data
after the sort? This is not going to happen with this approach.

Show us a sample of your data and we might be able to provide a solution.
Show us the raw data layout and what you want the linked data layout to look
like before and after sorting.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nate" wrote:

If I have linked cells in other tabs to my data field and I want to sort my
data field, how do I sort so that my linked cells in other tabs stay linked
to the specific data I originally chose.
--
Nate