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

There should be some code on Ron de Bruin's site that will get you started:

http://www.rondebruin.nl/tips.htm

You should probably pull in all the data to your workbook and then filter
for District 101 and discard the rest.

Mike F
"deejayh" wrote in
message ...

Hi,

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

I recieve 8 workbooks every month from 8 suppliers. They are saved in a
subdirectory under c:\audit. For example: supplier1 subdirectory-with
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 all
subdirectories of c:\audit, looks at each workbook, selects all rows
that = district 101.

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


--
deejayh
------------------------------------------------------------------------
deejayh's Profile:
http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=540973

Thanks for the reply Mike,

Funny thing is I am using code from http://www.rondebruin.nl

But I don't know how to expand this to check a column - "District" an
to bring in data from the corresponding row?

Any help appreciated

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

Thanks for the reply Mike,

Funny thing is I am using code from http://www.rondebruin.nl

But I don't know how to expand this to check a column - "District" and
to bring in data from the corresponding row?

I would also like for the user to select from a dropdown a "District"
and then for the code to run. If that could be possible?

Any help appreciated

Regards,
Dave


--
deejayh
------------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=540973

Hi deejayh

I try to update the site with a filter example next week

--
Regards Ron de Bruin
http://www.rondebruin.nl


"deejayh" wrote in message
...

Thanks for the reply Mike,

Funny thing is I am using code from http://www.rondebruin.nl

But I don't know how to expand this to check a column - "District" and
to bring in data from the corresponding row?

I would also like for the user to select from a dropdown a "District"
and then for the code to run. If that could be possible?

Any help appreciated

Regards,
Dave


--
deejayh
------------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=540973

Hi Ron,

Many thanks for your help. I am visiting your site every day:)

Hopefully you will add this soon, as I have to have it completed by
next Tuesday -no pressu(

Thanks again,

All the best,
Dave


--
deejayh
------------------------------------------------------------------------
deejayh's Profile: http://www.excelforum.com/member.php...o&userid=34110
View this thread: http://www.excelforum.com/showthread...hreadid=540973