opening a worksheet from another Book

[Stu]

I am trying to create an inventory that uses a master
list on one worksheet (the description of the item) to
open the worksheet in another workbook that contains the
journal for that item. When I use hyperlink I can't get
Excel to go to the specified sheet.
Any advice?

 

[Dave Peterson]

I inserted a hyperlink (insert|Hyperlink) and pointed at:
C:\My Documents\excel\book4.xls#sheet3!c19

And it opened to that sheet with C19 selected.

I used:
=HYPERLINK("C:\My Documents\excel\book4.xls#sheet3!c19","ClickHere")

And it worked ok, too.

How are you adding that hyperlink?

 

[Stu]

I had been using right click, the formula bar and
insert|hyperlink. I had been clicking in the cell I
wanted the link to appear, then adding the link, going to
the book I wanted and clicking the sheet I wanted to
bring up. I was getting error staements that the path was
wrong and other things. It's working now, so I guess
using your method, then noticing the bookmark button to
access the sheet was a big help. Thanks.