ExcelBanter - Creating a hyperlink to a cell on a different sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating a hyperlink to a cell on a different sheet (https://www.excelbanter.com/excel-worksheet-functions/123391-creating-hyperlink-cell-different-sheet.html)

Bob

Creating a hyperlink to a cell on a different sheet

I'm trying to create a hyperlink on Sheet1 that will take me to a cell on
Sheet2 when clicked. The formula I created is:

=HYPERLINK(Sheet2!A6)

But when I click on the link, I receive the following error message:
"Cannot open the specified file."
Can anyone tell me how to fix my formula so it works?
Thanks, Bob

Bob

Creating a hyperlink to a cell on a different sheet

I just figured it out:
=HYPERLINK("#"&CELL("address",Sheet2!A6),"?")

"Bob" wrote:

I'm trying to create a hyperlink on Sheet1 that will take me to a cell on
Sheet2 when clicked. The formula I created is:

=HYPERLINK(Sheet2!A6)

But when I click on the link, I receive the following error message:
"Cannot open the specified file."
Can anyone tell me how to fix my formula so it works?
Thanks, Bob

All times are GMT +1. The time now is 01:37 AM.