I need to be able to search 5 or 6 separate excel files that in turn hold
around 10,000 rows of customer data each and find precise records...

For instance I need to find PAUL SMITH of LONDON with postcode E17 4AJ, how
can I do this simply?

Unfortunately I do not have that option. The only option I have is to
search each of the files and as opposed to opening each one individually and
searching I'm sure there must be a way I can automatically search each one
from one location and produce the desired results.

It doesn't matter if the code is slow and crude... I just need something to
get my teeth into!!!

Regards

Scott

Sorry for the repost, its just im sure there is a solution!