ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   creating hyperlinks linking to other worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/74863-creating-hyperlinks-linking-other-worksheets.html)

tope12

creating hyperlinks linking to other worksheets
 
I know how to make hyperlinks that link to websites and documents on other
drives. My question is:

Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.

*Im not yelling. There's no option in this post for bold, so i just used
uppercase.

Michael

creating hyperlinks linking to other worksheets
 
Hi tope12. I was able to create a hyperlink to another sheet in the same
workbook by giving the workbook name as the address and then going to
bookmark. It did not open in a new window, however. You can also specify
the cell location in the target sheet. HTH
--
Sincerely, Michael Colvin


"tope12" wrote:

I know how to make hyperlinks that link to websites and documents on other
drives. My question is:

Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.

*Im not yelling. There's no option in this post for bold, so i just used
uppercase.



All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com