I have a drop down list in one workbook and want to have it look up a dynamic
named range in another workbook, can this be done or does the list have to be
in the same workbook?