#How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link)

[krunal123]

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link)

# i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

 

[julhs]

If I understand you correctly try this.

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

'SheetName'!Cell#

Hyperlink address should now look bit like this

TestBook.xlsm'TestSheet1'!A1

PS. You may see %20's in the Hyperlink address, that is only due to spaces in the WorkBook name

 

[julhs]

Slight correction!
Hyperlink address should look bit like this

TestBook.xlsm#'TestSheet1'!A1