title: Excel - move a whole row into the next worksheet if the text in a particular cell of the first worksheet is Y (or Yes)
body: <p>I am trying to set up a formula where worksheet 1 is a list of dates, names and the final column (I) is a simple Y or N (for Yes or No).</p>
  
  <p>If the answer is Y (or Yes) then I would like the entire row to be copied into the next worksheet (worksheet 2) and if the answer is N (or No) then it does not go onto the next worksheet.</p>
  
  <p>Is this possible to do, and if so how can i do it by cell formula (I don't want to change the srcipt module if possible)?</p>
  
  <p>Any guidance would be gratfeully recieved.</p>