Forum Discussion
Adding a hyperlink to another excel spreadsheet
Hello Im trying to create a summary spreadsheet where a number of other spreadsheets are added from to give a grand overview of our work load. when adding this I also want to be able to add a hyperli...
hi Jan
Ive looked at help and it hasnt helped, im trying to link the hyperlink cell which is a variable from the above paths and file names etc. so im trying to make that cell the path for my hyperlink.
It is very simple. Suppose the cell with the Path is cell B9 and the one with the name of the file is cell B8. Then enter this formula into the cell next to Hyperlink:
=HYPERLINK(B9&B8)
That is all there is to it.
You can have the cell display some other text than the entire path and name of the file as follows:
=HYPERLINK(B9&B8,"Click here to open "&B8)
=HYPERLINK(B9&B8)
That is all there is to it.
You can have the cell display some other text than the entire path and name of the file as follows:
=HYPERLINK(B9&B8,"Click here to open "&B8)