Lookup across multiple spreadsheets

R

Rob76

Hi, I was wondering if it is possible to auto grab and insert data (via
Lookup??) between two different spreadsheets (in different folders)

eg,
Grab data from Cell A1 in "C:\Excel01\Spreadsheet01.xls"
and place into Cell B1 in "C:\Excel02\Spreadsheet02.xls"

Any help would be a life saver!

Thanks
 
M

mrice

Something like

=VLOOKUP(A1,'C:\Documents and Settings\Martin\My
Documents\[Book2.xls]Sheet1'!$A$1:$B$1,2,0)

should do the trick.
 
Top