Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup last used Row un closed Workbook
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getvalue from closed workbook | Excel Discussion (Misc queries) | |||
Lookup function Closed files Excel | Excel Worksheet Functions | |||
Linking to a closed workbook | Excel Worksheet Functions | |||
Value from a closed workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |