#1
|
|||
|
|||
Excel Help Needed
Having a problem with hyperlinks in Excel. I want to hyperlink one cell in a spreadsheet to another cell. If I resort the data in the spreadsheet and the first cell moves somewhere else, I would like the hyperlink to find the new location. How do I do this (if it is possible)?
ie I have some data in cell B1 and when I click a hyper link at Cell C3 it finds the data at B1. I re-sort my spreadsheet and the data in B1 has now moved to B5 and the link at C3 is now at C1. When I now click the hyperlink at C1 I want it to go to B5. |
|
|