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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Put the workbook name in square brackets in front of the link text:
Code:
=HYPERLINK("[MyBook.xls]'"&A1&"'!A1";"Contact "&A1)
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,216,084
Messages
6,128,726
Members
449,465
Latest member
TAKLAM

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
Back
Top