Hi I am trying to create a hyperlink to a file which i can do ok but i need the hyperlink to use the value of a cell as the file name. for example my hyperlink is in cell B1 but and i am setting the hyperlink to a word document in my documents, however i would like the hyperlink to use the value of cell A1 as the file name for the hyperlink when it looks in my documents for the word file. can this be done??
Try this formula in the cell where you want the hyperlink.