title: Excel - Macro to compare multiple rows then copy to different worksheet
body: <p>I am trying to figure out a Macro to copy a row of data to a new worksheet once my conditions are meet.  I found another question answer but it is too different for me to figure it out: <a href="https://stackoverflow.com/questions/84331/excel-macro-to-conditionally-copy-rows-to-another-worksheet">Other Answer</a></p>
  
  <p>What I have is a 30000+ row and BB columns of data.  I want to compare data in one column from row to row and when I find the sequence I want copy the last row in the sequence to a different worksheet.  Sample Data:</p>
  
  <p>Numbers - Other Data - Other Data... <br/>
     1    -    xxx     -     xxx<br/>
     0    -    xxx     -     xxx<br/>
     1    -    xxx     -     xxx<br/>
     1    -    xxx     -     xxx<br/>
     0    -    xxx     -     xxx<br/>
     1    -    xxx     -     xxx<br/>
     1    -    xxx     -     xxx<br/>
     1    -    yyy     -     yyy<br/>
     0    -    xxx     -     xxx<br/></p>
  
  <p>In this case, I would want to find the sequence of three ones and copy the row with yyy data into a new worksheet.  Your help is appreciated.</p>