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
