opening worksheets

  • Thread starter Thread starter stu
  • Start date Start date
S

stu

I am trying to get a description in a cell on a worksheet
in one workbook to open a related worksheet in another
workbook. I have tried using HYPERLINK but it only opens
the workbook and not the correct worksheet.
Can this be done?
Thanks in advance
 
With the path in B2, file name in C2 and sheet name in D2:

=HYPERLINK(B2&C2&".xls#"&D2&"!A1",C2)
 
Back
Top