Lookup across multiple spreadsheets

Giganews Newsgroups
Subject: Lookup across multiple spreadsheets
Posted by:  Rob76 (Rob76.27cd1b_1146844203.2839@excelforum-nospam.com)
Date: Fri, 5 May 2006

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

--
Rob76
------------------------------------------------------------------------
Rob76's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34167
View this thread:http://www.excelforum.com/showthread.php?threadid=539308

Replies