how to maintain hyperlink between worksheets after sorting

G

Gallatin

I want to link a cell in worksheet A to a specific name in worksheet B
(rather than a specific cell number). I re-sort worksheet B and want the link
to stay with the "name" rather than the cell. Can this be done?
 
G

Gallatin

Thanks. This might work.



David McRitchie said:
How about use of VLOOKUP
VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
or the use of INDEX and MATCH also briefly described there.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Gallatin said:
I want to link a cell in worksheet A to a specific name in worksheet B
(rather than a specific cell number). I re-sort worksheet B and want the link
to stay with the "name" rather than the cell. Can this be done?
Click to expand...
Click to expand...
 
Top