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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 0
Linking workbook to multiple worksheets 1
Excel Protection 2
Excel Count If Formula Question 1
Lock worksheet, based on dropdown selection prior worksheet 9
Excel Move or Copy Stopped Working? 0

Back
Top