hyper linking
 

Hello,

I need some help with hyperlinking. I know how to hyperlink from a
cell, to a word document, to an excel document, and even to other cells
or worksheets within the same document.

My question is how do you hyperlink from a cell to a specific worksheet
inside of a seperte excel file?


basically i want to click on a link in one excel file and have that
link pull up a specific worksheet inside of difrent excel file.

Thanks for the help



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

hyper linking
 

Hi thenine,

You can do this with the HYPERLINK worksheet function:

=HYPERLINK("[c:\book1.xls]Sheet1!G70","Go to Book 1")

Regards,

Jake Marx
MS MVP - Excel


"thenine" wrote in message
...
Hello,

I need some help with hyperlinking. I know how to hyperlink from a
cell, to a word document, to an excel document, and even to other cells
or worksheets within the same document.

My question is how do you hyperlink from a cell to a specific worksheet
inside of a seperte excel file?


basically i want to click on a link in one excel file and have that
link pull up a specific worksheet inside of difrent excel file.

Thanks for the help