Hi all,

I am try to link to another workbook. Easy enough if the book is known.

However, I need the user to select the location of the book, which then updates the sheet.

Assume H2 is the location and name of the workbook (e.g. C:\Directory\Workbook.xls), I tried:

=INDIRECT('[' & H2 &']SheetName'!$H$15)
This isn't working and i'm probably missing something minor.

Can someone suggest the correct formula plz

Cheers