How to query from two worksheets - Complex?

[masai_chadi]

I have two worksheets:

WS1, contains Jobs each with one or many Qualifications Requirements

WS2, contains Employees each with one or many Qualifications

For each Job, I would to assess the Required Qualification(s) an
identify all Employees that have the required Qualification(s).

For example,

- Job Asst Terminal Manager must have Qualifications Radio Trainin
and First Aid.
- If any employees that have both the Radio and First Aid should b
extracted.

How would I achieve this in Excel 2002? Thanks.

Masa

 

[BrianB]

It would be possible to do the job with a macro, but I cannot advis
without knowing how your employee data is organised. I suggest yo
re-post with this information (many of us do not read messages alread
answered).

This, really, might be trying to make the best of a bad job. I thin
you will need to organise your employee data so that each qualificatio
has its own column with a "Yes" against each employee who has tha
qualification. This would make the sorting/extraction process easy
perhaps using Data/Filter/Autofilter. The re-organisation of data an
the subsequent operation could, of course, be carried out using
macro