Linking worksheets

[bladen]

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.

 

[alansidman]

='worksheetname'!$A$1

Add the exclamation mark

 

[BrianJN1]

If I read you correctly I'd use:
=worksheetname!A1
Now, if the worksheet has a space like "work sheetname"
I'd go for: ='work sheetname'!A1 but both still allow you to use $A$1 if that is necessary.

 

[bladen]

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.

I figured out I had to remove a previous hyperlink. Thanks