Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks and sorting data
I have two sheets in my Excel 2003 workbook. On both sheets column A
contains a hyperlink in each cell that will jump to the next sheet of that same cell. For example, if the user clicks on A3 of sheet 1 the hyperlink will take them to sheet 2 cell A3. Sheet 2 is set up the same way with hyperlinks. The problem I ran into is if I sort the data - columns A thru D, on sheet 1 - the hyperlinks won't work on sheet 2 because the cell reference changes on sheet 1 when I sort the data. Is it possible to create a hyperlink or something in Excel that matches text and will jump back and forth between the sheets. For example, sheet 1 contains column A - Project Name (which are currently my hyperlinks) , sheet 2 contains column A - Project Name. I want to be able to click on the Project Name and it take me to that same Project Name on the other sheet and vice versa. Then when I sort, it won't be dependant on the cell reference because it changes when I sort. Any ideas????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting links | Links and Linking in Excel | |||
up-date hyperlinks in Excel | Excel Worksheet Functions |