title: How to filter not equal to data based on list in cells Excel VBA
body: <p>I'm trying to filter my data based on a list of criteria. The list of criteria will be maintained on the actual spreadsheet since it needs to be updated by other users in column Z.
   <a href="https://i.stack.imgur.com/56qqp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/56qqp.png" alt="enter image description here"></a>
  I tried using an advanced filter, and eventually I was going to implement it in VBA  but it didn't return any values. The size and length columns are intentionally left blank. I want it to return all the data in the table on the left so that none of the words in the table on the right show up. </p>