Hyperlinks

[meJoanne]

I want to connect to workbooks
a hyperlink from one cell to another cell in a different existing workbook

 

[meJoanne]

Both workbooks have 11 sheets each
so I want to link the basics information of one worsheet to another from another workbook. So if someone whats to know more info of thet topic it will be link to the specific cell of the specifc sheet of the specific book. Can someone help?

 

[Eric W]

Welcome to the board.

You can use the HYPERLINK function like this:

=HYPERLINK("[C:\MyFolders\Excel\Book1.xlsm]sheet1!C5","Basic Info")

You need the fully qualified path to the other workbook, then the rest of the address.