The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dynamic Hyperlinking!

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Dynamic Hyperlinking!

Resolved · High Priority · Version 2003

ReplyFri 19 Jun 2009, 08:09Delegate Gareth said...

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

ReplyFri 19 Jun 2009, 16:03Trainer Simon said...

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.

Excel articles

· How Excel Can Boost Even The Smallest Business
· Microsoft Excel Courses Teach Advanced Macro Techniques
· A Picture Is Worth A Thousand Words (Or Numbers)
· Why Printing Needn't Be A Grey Area In Excel
· Excel Brings You The Tools To Spice Up Your Spreadsheets

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips

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

I've created a form in access for our project database that I now want to send out to team members in different locations to fill in. At the moment they are filling the information required into a Word or Excel form and I am then typing the information in..