You can use Data | Import External data | New Database Query and select
Excel, select the Excel file that has the source data, create a query
by selecting fields you wish to bring across, apply any critera to
filter out data you don't want, then return the data back to Excel.
Select properties and check 'Fill down formulas in columns adjacent'.
You can select 'Refresh data on file open', this will then
automatically pull your data through from the source file whenever the
target file is opened.


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=519687