Using Hyperlinks with the Index function.
 

I've created a new worksheet which displays individual records from my
spreadsheet using a combobox and INDEX functions.

The problem is that I lose my hyperlinks when I try to call them into the
new page.

I have two hyperlinks which are included in:
=PROPER(HYPERLINK(McAlpines&(TRIM(K2&" "&A2))&".xls","File"))
and
=IF(N8="", " ",PROPER(HYPERLINK(PhotoPath&(TRIM(B8&" "&A8))&".jpg","Photo")))
Where McAlpines, Sharkey etc are root addresses in the second worksheet.

The Hyperlionks are located in the I and L columns:

Do you have a formula that I can use in an adjacent cells (J and M) which
will display the full path of the hyperlink, so that I may then try for
example:

INDEX(HYPERLINK('FirstSheet!B2),H3)
in my new Worksheet.

Regards
Dylan Dawson
Scotland

Using Hyperlinks with the Index function.
 

It's okay I managed to work this one out myself.
"DDawson" wrote in message ...
I've created a new worksheet which displays individual records from my
spreadsheet using a combobox and INDEX functions.

The problem is that I lose my hyperlinks when I try to call them into the
new page.

I have two hyperlinks which are included in:
=PROPER(HYPERLINK(McAlpines&(TRIM(K2&" "&A2))&".xls","File"))
and
=IF(N8="", " ",PROPER(HYPERLINK(PhotoPath&(TRIM(B8&" "&A8))&".jpg","Photo")))
Where McAlpines, Sharkey etc are root addresses in the second worksheet.

The Hyperlionks are located in the I and L columns:

Do you have a formula that I can use in an adjacent cells (J and M) which
will display the full path of the hyperlink, so that I may then try for
example:

INDEX(HYPERLINK('FirstSheet!B2),H3)
in my new Worksheet.

Regards
Dylan Dawson
Scotland