ExcelBanter - How do I set the hyperlink to reference a cell for the file name?

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

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

- - How do I set the hyperlink to reference a cell for the file name? (https://www.excelbanter.com/excel-worksheet-functions/209515-how-do-i-set-hyperlink-reference-cell-file-name.html)

Quest41067

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.

FiluDlidu

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.

All times are GMT +1. The time now is 10:14 AM.