Menu
I would like to know how to create a hyperlink from one excel sheet to another, automatically through a script, based on equal text values that both cells in their respective sheets have.
If this can be done without a script, using a formula of some kind (like VLOOKUP) this would be preferable.
thanks for your time.
424
On the worksheet, select the cell where you want to create a link. On the Insert tab, select Hyperlink. You can also right-click the cell and then select Hyperlink... on the shortcut menu, or you can press Ctrl+K.
To link to a certain web page, you can simply type its URL in a cell, hit Enter, and Microsoft Excel will automatically convert the entry into a clickable hyperlink. To link to another worksheet or a specific location in another Excel file, you can use the Hyperlink context menu or Ctrl + K shortcut.
Click Cell Styles from the Home Tab and select Hyperlink and viola - all the cells change to clickable hyperlinks.
Right click on the cell and select copy, or use the arrow keys to move the selection point to the cell with the hyperline then copy, ie CTL C and paste into the new workbook.
Hyperlink appears as a regular text string Solution: Double-click the cell or press F2 to enter the edit mode, go to the end of the URL and press the Space key. Excel will convert a text string into a clickable hyperlink.
=HYPERLINK("#" & ADDRESS(MATCH(A1, B1:B5, 0), 2), "Link")
=HYPERLINK("#'My Database'!" & ADDRESS(MATCH($A1, 'My Database'!$A:$A, 0), 1), "Link")
=HYPERLINK("#'" & A1 & "'!A1", "Link")
=HYPERLINK("#" & CELL("address", INDEX(INDIRECT(C3 & "!A:A"), MATCH(A1, INDIRECT(C3 & "!A:A"), 0))), "Link")
There's a sample sheet found here where you can see these applied: 3D Hyperlink Examples
62
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
