Data Sort
Instead of linking to others sheets like
=Sheet1!A1
link using INDIRECT
=INDIREC("Sheet1!A1")
Even after sorting they will point to the original cell
"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
|