Advanced Filter not working

Question

Hello,

Can someone help me understand why this advanced filter isn't working?

There is 2000 rows this time with project numbers 8 characters but there could be training blanks. There are resource names in Column B but sometimes just blanks. There are numbers in column C with some also being 0 and spaces.
WE want to exclude any rows that include 3 CSR numbers which are CSR 1234, CSR 1238, CSR 1239 in Column A header called CSR. We also want to exclude any rows that have spaces in Column B Header name Resource. We also want to exclude any rows with zeros or spaces.
We set up the advanced filter to select all 2000 rows Column A through C and the Criteria Range $E$1:$G$5 where the column names are the same.

We would really like this to be done through VBA but we can't even get this to work.

We have 3 column fields Criteria-------------------------------
Column A Column B Column C Column E Column F Column G
CSR Resource Actuals CSR Resource Actuals
CSR 1234 John Smith 1.00 <>CSR 1234*
CSR 1235 <>CSR 1238*
CSR 1236 Joe Smith 2 <>" "
CSR 1237 Pete Smith 4 >0
CSR 1236 John Smith 3
CSR 1236 Pete Smith
CSR 1238 Joe Smith 2
CSR 1239

Thanks

Answer 1

Excel 365
Advanced Filter (in the year 2011)
With VBA macro.
Can be done easier with really advanced Power Query.
https://www.mediafire.com/file/7zalh4fw0yip08l/07_23_11a.xlsm/file
https://www.mediafire.com/file/m39am2e1g8an9hb/07_23_11a.pdf/file

Answer 2

My apologies for being so late on this. Until recently I was not able to see that someone actually responded to the questions I sent. Not sure what the issue was.