title: Copy an entire row to another worksheet if a cell has content matches the condition VBA-EXCEL
body: <p>I would like to copy the Name and Description If Quantity on and is equal to zero so I can order the fruit that I do not have.  It starts from A2 whenever it see "STOP" then it stops. </p>
  
  <p><img src="https://i.stack.imgur.com/IFYnq.jpg" alt="enter image description here"></p>
  
  <p>I have the code:
  <img src="https://i.stack.imgur.com/jARaG.jpg" alt="enter image description here"></p>
  
  <p><b> However, the code does not stop by itself, I have to break it when it runs. It copies all empty rows between and entire row when I only need to have first 2 columns. My questions are 1. how to let the program knows it should stop when see "STOP" at column A? Only copy none empty row? and only copy first two column (or the number of columns that I would like to have)?</b></p>