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:
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,687
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:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,110
Messages
5,835,439
Members
430,357
Latest member
RadStorm20

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top