Hi,

Is there any way to import certain data from multiple workbooks held i
a directory and sub directories below that.

I recieve 8 workbooks every month from 8 suppliers. They are saved in
subdirectory under c:\audit. For example: supplier1 subdirectory-wit
all the audits for every month (depending on the time of year!)
January.xls, February.xls.....

The audit for each month contains:
Region, District, Store No, Score1, Score2, Score3, Score4
4, 101, 2345, 2, 4, 3, 1,
5, 206, 7298, 3, 1, 1, 4,

I want to be able to import all sites from District 101.
In other words, I click a button, (vba?) then goes into al
subdirectories of c:\audit, looks at each workbook, selects all row
that = district 101.

Can this be done?
Hopefully I have explained correctly.
Regards,
Dav

--
deejay
-----------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...fo&userid=3411
View this thread: http://www.excelforum.com/showthread.php?threadid=54097