| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to maintain hyperlink between worksheets after sorting
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to maintain hyperlink between worksheets after sorting
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" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to maintain hyperlink between worksheets after sorting
Thanks. This might work.
"David McRitchie" wrote: 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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to maintain hyperlink in excel to pdf conversion | New Users to Excel | |||
| sorting worksheets based on a cell value | Excel Worksheet Functions | |||
| sorting with linked worksheets | Excel Discussion (Misc queries) | |||
| How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) | |||
| Sorting problems with other worksheets!!! | New Users to Excel | |||
Linear Mode
