Hello. I am an excel user for many years but have never used the hyperlink function before.

I want to create a "Click Here" type function that will move you to a certain cell in another worksheet.

I played around with this for a while now with no luck. Went to the help function and got the formulas and I have tried the below. It does not work.


=HYPERLINK("[b]a!j17","Consolidated")

"B" is the workbook name and "a" is the worksheet I want to move to and "j17" is the cell in the "a" worksheet

Thanks.