creating hyperlinks linking to other worksheets

[Guest]

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.

 

[Guest]

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