Filter And-And

[Guppie1]

Hi, 

In the attached file there is 'combobox2'. With this dropdown I wish to filter the selected employee in column 4. But also I wish to see the project(s) in column 2 where the employee is working for. Result should be:
<project 1>
                   <eg 'Peter'> … rest of columns
<project 2>
                   <Peter> …. rest of columns

I wish to be able to return to a complete unfiltered page afterwards (another button 'refresh'?)

Also: is it possible to have the data filtered in order bij planning? F.e.: -now is week 1-: if Peter would work for project 4 in week 1; and for project 3 in week 2, that project 4 would be the first in row. Looking from this point on (lets say: now is week 1).

Hope this is possible!
And yes, I know it would be easier if each cell was filled with data. But I have tried this and cannot make that foolproof (long story; believe me). 
Best regards and happy new year,
Martin

Filter1.xlsm

[emielDS]

vooreerst van harte welkom maar

Waarschijnlijk heb je het gemist maar de voertaal hier is nederlands