Hyperlinks

The UK's most regular instructor-led training courses.
Training information: excel computer training · Microsoft excel training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version 2003

28 posts

ReplyMon 29 Jun 2009, 14:25Delegate Gareth said...

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

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	1		£224	£225
2003	Thu 18 Mar 2010	Limehouse	0	FULL
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	6		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 79 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

2,024 posts

ReplyMon 29 Jun 2009, 14:27Trainer Amanda said...

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

28 posts

ReplyWed 1 Jul 2009, 12:03Delegate Gareth said...

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.

748 posts

ReplyMon 20 Jul 2009, 09:37Trainer Stephen said...

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.

· Interesting Things About Charts In Excel 2003
· Interesting Lifestyle Applications for Microsoft Excel
· Training Budgets In A Bad Economy
· Correcting Numerical Glitches In Excel
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips