Formula problem with hyperlinks in Excel

[Tompanilla]

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?

 

[GlennUK]

Put the workbook name in square brackets in front of the link text:

=HYPERLINK("[MyBook.xls]'"&A1&"'!A1";"Contact "&A1)

 

[Tompanilla]

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!

 

[GlennUK]

My pleasure