krunal123

Board Regular
Joined
Jun 26, 2020
Messages
72
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

julhs

Board Regular
Joined
Dec 3, 2018
Messages
80
Office Version
  1. 2010
Platform
  1. Windows
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
Excel Formula:
'SheetName'!Cell#

Hyperlink address should now look bit like this
Excel Formula:
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

Board Regular
Joined
Dec 3, 2018
Messages
80
Office Version
  1. 2010
Platform
  1. Windows
Slight correction!
Hyperlink address should look bit like this
Excel Formula:
TestBook.xlsm#'TestSheet1'!A1
 

Watch MrExcel Video

Forum statistics

Threads
1,127,099
Messages
5,622,700
Members
415,922
Latest member
gemmatay88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top