title: Multi-Criteria Selection with VBA
body: <p>I have created a macro that allows me to open multiple files based on their names and copy sheets into one on another workbook. Now I would like to add some criteria, I determine the last row with data. I used this: </p>
  
  <pre><code>lstRow2 = alarms.Cells(alarms.Rows.Count, "A").End(xlUp).Row
  </code></pre>
  
  <p>And now i want to go through each row and check if column <code>G</code> of each rows contains strings like (<code>"condenser", "pump"</code>, etc) if yes copy the row but not the whole row, only a series of columns belonging to the row (for example for each row that match my criteria  copy those columns <code>A-B-X-Z</code>) and finally copy all that in another sheet.</p>
  
  <p>Thanks for your help </p>