title: Use Google Apps Script to loop through the whole column
body: <p>I am trying to loop through the whole row in my google sheet and copy some of the data from one sheet to another. The list will get longer over time.</p>
  
  <p>More specifically: If input in column B equals "blue", than copy the values from column A and C into another sheet.
  Do this for all columns till the end of the column.</p>
  
  <p>Link to my spreadsheet: <a href="https://docs.google.com/spreadsheets/d/1xnLygpuJnpDfnF6LdR41gN74gWy8mxhVnQJ7i3hv1NA/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1xnLygpuJnpDfnF6LdR41gN74gWy8mxhVnQJ7i3hv1NA/edit?usp=sharing</a></p>
  
  <ul>
  <li>The loop stops when the colour does not equal blue. Why?</li>
  <li>As you can see I used a for loop. Is that even the way to go?</li>
  <li>Can I do anything about the speed of the code execution?</li>
  </ul>
  
  <p>Any comments, hints or help are highly appreciated.</p>
  
  <p>Regards!</p>