VBA Autofilter Multiple Columns (Union instead of Intersection of Criteria)
<p>Goal:
I've got SKU's flagged various ways in a wide table. Users will  be selecting what flags they want viewed using checkboxes. I want to filter data that displays <strong>any</strong> of the flags.</p>

<p>I'm familiar with the code </p>

<pre><code>With Sheet1
     .AutoFilterMode=False
          With .Range("A1:D200")
               .Autofilter
               .Autofilter Field:=3, Criteria 1:="X"
               .Autofilter Field:=4, Criteria 1:="X"
           End With
End With
</code></pre>

<p>But this only gives me the intersection of those two conditions. I want the union of those conditions. How can I use the filter to give me the union of the conditions? Is there any easier way to do this? </p>

<p>The only other method I know to use is to loop through the rows individually and checking the criteria, which I know how to do, but seems slow. </p>

<p>(I know that making the data tall instead of wide would be ideal, but the users use the raw data to track aspects and that is not feasible.)</p>