Scott,
Some questions:

- How is the data organised e.g from your example it could be fields with
FirstName, SurName, City, PostCode?
- How do you want to enter your selection(s) e.g. via Userform?
- Where do you want to put the selected data?

As answers to your previous post indicate, this is unlikely to be simple but
more info is needed to make a judgement on how best to tackle it.


"Scott" wrote:

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!