Filter a table according to a table of criteria

[HSieb]

Hello everyone,

the goal is to have a file, where I can choose a workstation and get a list of all employees, that have the required skills.

I have two tables, one with a list of skills and a required grade for each workstation. Then a list with employees and their respective grade in each skill.

I created a Pivot to visualize the neccessary skills for each workstation, but cannot find a solution to get a list of possible staff for the chosen workstation.

Any good idea or pointer in the right direction would be most helpful...

Cheers!

[excel_bat]

Hi! Have a look at the file attached. It is a simple solution, but may be it helps!

[HSieb]

Hey, that is actually nice and easy. I probably use for starters, but for the real thing I have 42 workstations, 96 skills and 90 employees... hm, but with the use of some filters it should be workable. Maintenance will be a pain though

[excel_bat]

Some heavier stuff! I did not have time to optimze it, but including some VBA code can help to perform the task. Hope it helps!

[HSieb]

Thats actually looks perfect! That will help... thank you so much!

[excel_bat]

Great! Glad to hear it works.

If you are happy with this solution, may be you could click the little star * below and give some Reputation

Thank you!