title: Advance AutoFilter to exclude certain values
body: <p>I want to filter a large list of names in a Sheet in excel.  In another sheet I have contained a list of names that I want to filter out and exclude from the larger list. How would I use the advanced filter to do this? I have tried this below but it is not seeming to work. My big list is in <code>K2:K5000</code> and my criteria is in <code>H2:H3</code> (The criteria will grow but I kept the list small for testing). Any help would be greatly appreciated!</p>
  
  <pre><code>Sub Filter()
      Sheet5.Range("K2:K5000").AdvancedFilter Action:=xlFilterInPlace, _
          CriteriaRange:=Sheets("Sheet3").Range("H2:H3"), Unique:=False
  End Sub
  </code></pre>