Formula problem with hyperlinks in Excel

Tompanilla

New Member
Joined
Nov 3, 2005
Messages
47
I am trying to create hyperlinks to different worksheets from column C.
The hyperlinks should take the cellinformation in column A and by that
make hyperlinks to the corresponding worksheet.

Have tryed this formula but it does not work:
=HYPERLINK("'"&A1&"'"&"!";"Contact "& A1)
By the formula I want cell C1 to make a hyperlink with the information in cell A1, and by that jump to the worksheet named like cell A1.

As the information in column A changes all the time it has to take the value from the A cells to create the hyperlinks in column C.

Any suggestion how I can get this to work?
:confused:
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Put the workbook name in square brackets in front of the link text:
Code:
=HYPERLINK("[MyBook.xls]'"&A1&"'!A1";"Contact "&A1)
 

Tompanilla

New Member
Joined
Nov 3, 2005
Messages
47
Thanks Glenn! This works fine!

I have tried earlier with the bookname but probably missed some small details.
Very happy that you could give me the correct answer!
:biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,025
Messages
5,569,720
Members
412,289
Latest member
Kingchaos64
Top