Open both your Workbooks.
Click the cell in 1st Book where you want the Hyperlink to jump FROM.
Then right click the mouse, at bottom of dropdown list is “Hyperlink”, right click that
Then select your 2nd Book from the drop down list and click it.
Then go to your 2nd Book and make a note of the Sheet tab name that you actually want the “Hyperlink” to jump TOO
Go back to 1st Book
Then right click the Hyperlink you created and select “Edit Hyperlink”
At the bottom of the dialog box is the path name for your 2nd Book.
Then add the Worksheet tab name and a cell # to the end of that file path you see in the window
So you will be adding something like
Hyperlink address should now look bit like this
PS. You may see %20's in the Hyperlink address, that is only due to spaces in the WorkBook name