Hi
I need to use sumproduct in getting certain data I need from a closed workbook and the range changes depending on what is the last row defined in my Closed Workbook sheet in the example I attached.
I know indirect doesn't work with a closed workbook, and I try certain other methods which doesn't give me what I need as well...
Is there any ways I can make this, 'Closed workbook'!$A$1:$A$9, dynamic and still work on a closed workbook?
Bookmarks