Find, copy and paste specific values.

Hey there,
I'm trying to pull out some data from sheet with 40,000~ rows and about 300 employees.
example.jpg
I need to find values >0, sort it descending (by days) and exclude few JobNames. I tried to do that with aggregate and index formulas, but it's kind of slow on weaker PCs and I'm stuck now.
So, what I need to do is this:
1. Find Employee from P1 cell
2. Copy Job, Days, Sum, Average (these columns are not next to each other)
3. Exclude few specified JobNames in R1:R2 range
4. Paste it sorted descending by Days
Ideally it would work on combobox change.
Perhaps there is a better and faster way to achieve that? Any help is greatly appreciated! Thank you.

I tried this and It still runs macro every time I type a letter in combobox, without letting me to finish full string that I'm looking for e.g. I'm looking for "ABC", but it runs macro when it found "A" employee, then when it found "AB" employee and then finally "ABC". Anyway It's not a big deal, I can live with that. Nonetheless you've done amazing job and I thank you for that!

Try adding this code to worksheet module

Please Login or Register  to view this content.