Lookup last used Row un closed Workbook
I want to add this to the end of the previous function:
=LOOKUP(10000000000,WeeklyForecastingRM!B:B)
Not sure what you mean by that?
This should work:
=LOOKUP(10000000000,'C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B:B)
--
Biff
Microsoft Excel MVP
"ryguy7272" wrote in message
...
I am trying to link to a closed Excel file with this path:
='C:\Documents and Settings\rshuell\Desktop\Weekly
Reporting\Friday\[WeeklyForecastingRM.xls]WeeklyForecastingRM'!B7
I want to add this to the end of the previous function:
=LOOKUP(10000000000,WeeklyForecastingRM!B:B)
Basically, trying to lookup the value in the last used row of a closed
Workbook. Can someone help out?
Thanks so much!
Ryan---
--
RyGuy
|