I would like to link text in a cell to another sheet/tab in my spreadsheet. For example, if I have 2 sheets ( ‘summary’ and ‘yearly budget’ ) how can I create a link on the summary tab that says Current Budget that links to my yearly budget sheet/tab?
I see no way to reference the actual sheet. I can reference a cell in the sheet ( =‘yearly budget’.A1 ) and get the value but that’s not what I want. I want a hyperlink, but when I insert hyperlink it only gives me a URL option.
For clarity, the sheets/tabs are in the same spreadsheet.
Any help is appreciated!