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?
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?