| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
