| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink based on cell value in a different worksheet
Hi there,
I'm attempting to create a hyperlink in Sheet2 that will open a folder whose name is stored in a cell in Sheet1. Here's what I've got so far: =HYPERLINK("I:\2007GSR\"&B7,"Link to Folder") B7 contains the folder name but this assumes the cell is on the same sheet as the hyperlink. How do I get the formula to realize it's not? Thanks. Bart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink to a cell in another worksheet | Excel Discussion (Misc queries) | |||
| How do I hyperlink to a specific cell in other excel worksheet? | Excel Worksheet Functions | |||
| How can I make a Hyperlink to a cell within another worksheet rela | Excel Discussion (Misc queries) | |||
| hyperlink or bookmark based on cell value | Excel Discussion (Misc queries) | |||
| hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
Threaded Mode
