Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic Hyperlinking!
Dynamic Hyperlinking!
Resolved · High Priority · Version 2003
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.
For upcoming training course dates see: Pricing & availability
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
Fri 26 Jun 2009: Automatically marked as resolved.
|
|
Why Upgrade To Dreamweaver CS4? The latest version of Dreamweaver is CS4 and, as with all software updates, many consumers are loath to shell out on an upgrade when they feel that there is nothing wrong with their existing version. However, there are definite advantages to be had in investing in the most current form of Dreamweaver. » Article: Dreamweaver course |
» Forum post: Forms |
» Tip: Check Names shortcut |



Course updates

