Sorting and linked data

[LesD]

Hi

Is there a way to link (between worksheets) to the
content of a cell, and not the cell reference itself?

I have a spreadsheet that contains 3 worksheets. Sheets 2
and 3 are linked to data in sheet 1 (which contains
names/addresses etc). In day-to-day use, data in each of
these sheets are sorted.

Sorting causes a problem in that if I link from sheet 2
to a person's name in sheet 1 and then sort the data in
sheet 1, the linked cell content in sheet 2 also updates.
The reverse also applies. Essentially, the links are to
to a cell reference and not the content so when data are
sorted the reference stays and the data are long gone.

Any help would be much appreciated.
thanks
Les

 

[David McRitchie]

Hi Les,
You might consider using VLOOKUP if you are going to
be sorting data. And you will be wanting to look for an
exact match.
http://www.mvps.org/dmcritchie/excel/vlookup.htm