Ga naar inhoud

Filter And-And


Guppie1

Aanbevolen berichten

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

Link naar reactie
Delen op andere sites

×
×
  • Nieuwe aanmaken...

Belangrijke informatie

We hebben cookies geplaatst op je toestel om deze website voor jou beter te kunnen maken. Je kunt de cookie instellingen aanpassen, anders gaan we er van uit dat het goed is om verder te gaan.