title: Delete rows if two criteria match
body: <p>I have two sheets with data and I would like to have delete rows in sheet1 if two criterias are matching. I've made a mindmap of an idea, so it is easier to understand.</p>
  
  <p><a href="https://i.stack.imgur.com/n1LOv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n1LOv.png" alt="enter image description here"></a></p>
  
  <p>I have done a very first part of the code what deletes rows when one criteria is matching, but it also deletes blank rows that I wanted to keep.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  Application.ScreenUpdating = False
  
  Dim iListCount As Long
  Dim x As Variant
  Dim iCtr As Long
  
  iListCount = Sheets("Sheet1").Cells(Rows.Count, "N").End(xlUp).Row
  
  For Each x In Sheets("Laoseis").Range("B4:B" &amp; Sheets("Sheet1").Cells(Rows.Count, "N").End(xlUp).Row)
    For iCtr = iListCount To 16 Step -1
      If x.Value = Sheets("Sheet1").Cells(iCtr, 14).Value Then
        Sheets("Sheet1").Cells(iCtr, 14).EntireRow.Delete
      End If
    Next iCtr
  Next
  Application.ScreenUpdating = True
  
  End Sub
  </code></pre>