Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

hyperlinks

ResolvedVersion 2003

Gareth has attended:
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Advanced course

Hyperlinks

Hey

Im trying to link from excel to a specific word document that looks up the text value of one cell and searches and finds the exact document in another folder.

For example in column AF I have a number like '56TD67890'.

On the company server I also have a word document that goes by the same name. Im trying to create a hyperlink to the server that takes me directly to the word document that matches the text value in column AF.

Is this possible?

Thanks

RE: Hyperlinks

Hi Gareth

Not sure about this one myself, I'll ask one of my colleagues to have a look at this for you tomorrow.

Kind regards
Amanda

RE: Hyperlinks

I have tried combining the concatenate function with the hyperlink but it doesn't work. Any advance on if this is possible?

Thanks in advance.

RE: Hyperlinks

Hi Gareth

I apologise for the delay in replying. I have been away from work for the last few weeks due to illness.

I realise that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.