Thanks very much for that Ron - I appreciate it.

Couple of other questions:
1) How do I add a Combo Box and set the value within your code?
for example on the combo you could select "201" then (with your code
goes into all the directories and selects all the data in a range o
B8:B400

2) How do I get it to search in all subdirectories below c:\Data?

Also how can I set the data to go into a specific sheet?

Thanks again Ron,
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