title: Need VBA code to filter with two conditions
body: <blockquote>
    <p>Closed. This question needs details or clarity. It is not currently
    accepting answers. Add details and clarify the problem you’re solving.
    This will help others answer the question. You can edit the question
    or post a new one.</p>
    
    <p>Closed 14 hours ago by SJR, Erik A, Amit Joshi.</p>
    
    <p>(Private feedback for you)</p>
  </blockquote>
  
  <p>I am new to VBA code . I have two cells with drop down values (C1) and (C2) . In C1 i have two values ex: A, B . In C2 i have drop down values x,y z. i Have applied filter on both. If i selects A and X is should go and filter the values with A and X similarly for others</p>
  
  <p>i written for one cell not able to combine both cells C1 and C2, is there a way using AND operator. we can achieve it?</p>
  
  <pre><code>For Each cel In Range("C2")
  
      If cel.Value = "A"  Then
  
  ElseIF If cel.Value = "B" Then
  </code></pre>