Hi all

I have a workbook consisting of approx. 10 worksheets, each containing
details of a member of staff, ie. what qualifications they have, what jobs
they can do etc.

I am hoping to create a separate worksheet altogether, in the same book,
that will help me 'find' people who are suited to a particular job. For
example, I could somehow type 'qualification one' and it would find anybody
who has qualification one.

Any idea of the easiest way to do this, or even if it's possible??? Would
this be easier in Access and then run Queries?

Thank you.