Re: Excel Help Needed
You can't do what you want directly but can fake it with a look up table. In a part of the spreadsheet that isn't going to be sorted put =a1 or whatever cell you want to hyperlink to. Then hyperlink to the cell in the table. You won't be linking to the actual cell after you sort, but will be hyperlinking to a cell that contains the value of that cell.
Why are you using hyperlinks instead of just grabbing the value in the cell?
|