Hi! I am creating a database. One sheet has a sort-able table of contents, and the other sheets have the specific data relevant to their headings. I already have made it so that I can hyperlink from the table of contents to the specific pages, but I am having trouble going the other way.
One thing this project needed was the ability to select sort-able data, so I created a peripheral sheet that handles hyperlinking back to the sort-able table of contents. What I am trying to achieve is a way to link from the specific data pages back to the table of contents in only 1 click, rather than clicking a hyperlink from the specific data pages to the peripheral sheet, and then clicking another hyperlink from the peripheral sheet to the table of contents.
On my peripheral sheet I am using this method to maintain the integrity of the hyperlinks and still allow it to be searchable.
To be brief, is there a way to create sort of a "pass-through" hyperlink where you click one thing, it goes to another which is instantly activated, and then takes you to a third place?
Bookmarks