title: Loop through cells in a range, check for a condition and save results on a different s/s
body: <p>I am trying to build a loop which would go through each cell in a row and each row in a range, check if the value in each cell is "apple" and it it is, copy the date the cell was checked for and save the date in a separate sheet next to the id for which the check was done. I would appreciate help on this. Thank you. <a href="https://i.stack.imgur.com/tVqr2.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p><a href="https://i.stack.imgur.com/tVqr2.png" rel="nofollow noreferrer">Sheet1</a>
  <a href="https://i.stack.imgur.com/4bfm2.png" rel="nofollow noreferrer">Sheet2</a></p>