Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set the hyperlink to reference a cell for the file name?
I am trying to set up a cell with a hyperlink that parts of the path can be
changed by other inputs such as other cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set the hyperlink to reference a cell for the file name?
Here would be an example:
=hyperlink("C:\"&A1&"\FolderX\"&left(B1,3)&"myFile .xls","This is where I can find "&C1&". Just click the cell") "Quest41067" wrote: I am trying to set up a cell with a hyperlink that parts of the path can be changed by other inputs such as other cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
hyperlink - PDF file - relative reference | Excel Worksheet Functions | |||
CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
Hyperlink - Passing a cell reference | Excel Worksheet Functions | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |