Gareth has attended:
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Dynamic Hyperlinking!
Hey,
I want to insert a hyperlink that takes a value from a column to help search and find the matching file in the destination folder.
For example in column D I have a client number along the lines of 56/GH/8976/098. I want Excel to take that value of column D, then link in to the file with the same name in the folder I want the hyperlink to go to.
I can do straight forward hyperlinks to a document that is fixed but I cant do one that will look up different names.
Any help with this much appreciated.
Thanks in advance.
RE: Dynamic Hyperlinking!
Hi Gareth,
Thank you for your question.
I have come up with a possible solution which I will outline below:
=HYPERLINK(CONCATENATE("C:\",D1,".xls"),D1)
This function will combine the location of the file with the value specified in the cell and file type and finally the value from the cell displayed as the hyperlink name.
As you are trying to link the client code with the filename, the client code cannot contain a / or a \ as excel files cannot be saved with a / or \ in the filename.
In a blank cell next to the client number, enter the formula above but change the cell reference and filename as appropriate. Copy and paste the formula where appropriate.
I hope this answers your question.
Regards
Simon
