title: Delete Entire Rows That Have Multiple Matching Cells
body: <p>I created a macro that will copy over some information from one sheet in my workbook to another to match some criteria so I may import the info into a program. Only problem is after the macro runs, there are some blank rows and a couple duplicates. I have 12 columns of info but I would like to have the macro look at and compare entries in columns <code>D,E,F,G</code> and <code>L</code> with the row above them. So <code>D2,E2,F2,G2</code> and <code>L2</code> would be compared to <code>D1,E1,F1,G1</code> and <code>L1</code>. IF all five of the entries in these cells match that of the previous row, then delete the entire row.</p>
  
  <p>I've found some codes that match one cell or looks for duplicates in a certain column but nothing to look and match multiple columns and I'm so new to this that I'm having trouble even getting started. </p>
  
  <p>Any and all input is welcome.       </p>