Thread: HyperLink within Workbook

Hello. I have used excel for many, many years but now would like to create a hyperlink within a workbook. Something like a button that will take you directly to another worksheet in the same workbook. I think Hyperlink is the only way to do this. I want to create something like 'Click here" to go to another worksheet.

Now I have played with the Hyperlink formula for a while with no luck.I have tried to trouble shoot this myself with no luck.

Here is what I typing in where "b" is the workbook name and "a" is the worksheet that I am trying to move to cell "j17".

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

Any help would be appreciated

Thanks - Both options work.

Much appreciated