Hyperlink to sheet in same workbook (referring to cell with name of sheet)

Hi,

I am trying to create a hyperlink from a summary sheet to another sheet in the same workbook.

I have accomplished my goal, but the function that I used contains the workbook name. I don't want it to contain the workbook name if it can be avoided.

I have attached an example for your reference.

Look at cells C2 and C3 for working hyperlinks. These work fine, but I don't want the function to contain the workbook name.

Look at Cell A5 for my attempt at creating a hyperlink the way I want it (without workbook name in function).

For the function in cell A5, I used instruction found here:
https://www.contextures.com/excelhyperlinkfunction.html About halfway down the page: "Link Within the Same File"

You had inverted commas in the wrong place around the reference to A1

Formula:

Please Login or Register  to view this content.