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 hyperlink of the file location to a certain cell.
Also i would like the filename to be variable so it an auto update the links when save and inserted into the summary spreadsheet
Can anybody help
6 Replies
Richard105 Hi. could you please elaborate a bit what you exactly want. I went through the sheet but couldn't get the issue.
If you could share a single example using the cell addresses, that'd be much helpful
thanks
Hi what im trying to do, and have had working to an extent is auto populate the snapshot below based on the file originally attached. what the macros within the attached file does is open this insert the required data to the next available line. but what im having to then do is manually add a hyperlink to the job number column so the attached file can be opened from this sheet.
Also as these files will be all over in lots of job folders im also trying to have the file name as a variable on the macro (not fixed as current) as sometime if these get moved or saved as something differently it loses the link (make it fool proof for other users)
not sure if that make any more sense?
- Check out the HYPERLINK function in Help.
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)
