Hyperlinks

[Ross]

Are you able to create a hyperlink between two workbooks
and specify which sheet the hyperlink should go to?

 

[J.E. McGimpsey]

Yes. Use the sheet name an cell reference as an anchor. For instance:

file:///<your path>\Book1.xls#Sheet2!A1