Hopefully this is possible without complex coding as I won't be the person curating this spreadsheet...
We have a large spreadsheet that is row upon row of case information, with each row representing a separate case. One of the columns in the information is "patient name". I've been asked if we can link that cell (patient name) from the main worksheet to a second worksheet (Summaries) that would simply be row after row of patient information with each patient being a separate row. So if you click on [Smith, John] in the main worksheet, you'll be taken to [Smith, John]'s row in the Summaries worksheet.
On the surface this appears simple. Hyperlink the [Smith, John] cell in the first worksheet to the corresponding cell in Summaries. However, names will be added as time goes on, and the Summaries sheet will need to be sorted alphabetically when that happens, so even though [Smith, John] might be Row 25 today, he could be row 40 in a week. Referencing Cell A25 from his entry on the main worksheet won't work, as next week A25 will have someone else's information.
So, how can I create a link from [Smith, John] on the main worksheet to [Smith, John] on the Summaries worksheet that will automatically adjust when the Summaries worksheet is resorted? I'm not sure if the main worksheet will ever be resorted, I suppose it's possible, so the link should stand up to that happening as well.
Impossible task? I can't seem to find a combination of hyperlink settings that work. Thanks for any suggestions you can provide.