Best way to get Excel to do this?

[chuckles1066]

I'd personally use Access for this but I've been asked to develop it in Excel.

There is to be a lookup sheet with employee names, which site they work at and various skills, training qualifications etc.

So, for example, the sheet might show Chuckles, his site is The Circus Of Horrors, his department is Children's Entertainment first aid trained would be y or n, trapeze artist grade would be 1 to 5, driving licence held would be y or n etc etc so that a complete picture in one table can be built up about every employee.

This will drive a userform or something, I imagine.

What I've been asked to do is create some sort of screen where, for example, someone can enter their requirements and it lists all qualified employees......so, above, if you entered the department as Children's Entertainment and driving licence held = y, it would bring back Chuckles (and anyone else who matched the criteria).

It's the classic select * from employees where........

Is this even do-able in Excel?

TIA.

 

[chuckles1066]

Thanks for your input guys, I have an old laptop running XP here somewhere, I'll have a play at the weekend.

 

[Aladin Akyurek]

Aladin

Thanks for the suggestion. Unfortunately I haven't been able to get that to work with Advanced Filter.

I didn't realize you were doing Advanced Filter...

 

[chuckles1066]

Thank you both very much for your time and excellent input.

Plenty of food for thought

I did try to twist their arms (again) re how simple it is via Access and a form but Excel is definitely the way they want to go.

It's going to be a long summer.......!!