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
|