Hello all,

I use alot of Excel in my job and I have run into a wall. I work in HR for an English school board in Quebec and I am trying to organize my list of janitorial workers to have it as user friendly for school sectretaries as possible.

OBJECTIVE: Filter the list of workers by various categories: AREA of WORK, NIGHT WORK, DAY WORK...

ISSUE TO BE SOLVED: I want to have above my entire list of workers a number of Drop down lists (I have no problem creating the lists with Data Validation). I want to be able to select in the Dropdown: AREA->Laval and NIGHT-> Yes to filter out only those workers who are listed as being available in the LAVAL area and willing to work nights.

I dont know how to link my filtering to the drop down lists.

Anyway if anyone could provide some insight, it would be greatly appreciated. Preferably nothing with VBA, I have much experience with formulas but almost none with VBA coding. Thanks again!

-Dawson