title: Filter for multiple combinations with VBA
body: <p>I am trying to perform 2 different filters within the same line. As you can see below, I am looking for 1 of 3 numbers in one field and 1 of 2 numbers in a separate field. I don't believe this is written correctly as its still pulling more data for the 2nd set then the variables I indicated. I suspect its simply around my 'And' or the 'Or' but need some help.</p>
  
  <pre><code>For i = 2 To rngData.Rows.Count
          ' Check cell of column 10 of row i and copy if matched
          If rngData.Cells(i, 10).Value = "303500" Or rngData.Cells(i, 10).Value = "604066" Or rngData.Cells(i, 10).Value = "613991" And rngData.Cells(i, 3).Value = "ACR/EM-1A" Or rngData.Cells(i, 3).Value = "ACR/EM-1D" Then
              ' Copy over to wsDalreq from row j
              j = j + 1
              rngData.Rows(i).Copy Destination:=wsTempinterior.Cells(j, 1)
          End If
      Next
  </code></pre>