Concatenated hyperlink

[tdartnell]

Hi

I am trying to figure out a concatenated hyperlink.

=HYPERLINK(CONCATENATE("[CSUL.xlsx]",A12,"!A7"),"Goto")

This is what I have got so far it links to the workbook CSUL.xlsx but not the Sheet and Cell. The sheet name is in Cell A12.

I think this is a problem with Parenthesis. If not concatenated the Workbook would have =HYPERLINK("[CSUL.xlsx]A12!B4","Goto" the two red Parentasis

the 2 red parenthesis.

Can anyone help

Thanks in advance

Toby

 

[Eric W]

Welcome to the forum.

Does the sheet name have any spaces in it? If so, try:

=HYPERLINK(CONCATENATE("[CSUL.xlsx]'",A12,"'!A7"),"Goto")

 

[tdartnell]

No spaces in sheet name