Coping a row from sheet to another based on whether the candidate is accepted or rejected : <p>Now, I'm trying to create a semi automated tool in google sheets for hiring (self-use). I need a code to copy the whole row based on whether the candidate is (Accepted or Rejected) if the candidate is accepted I want to copy the whole row and paste it in the (Accepted Candidates Sheet).</p>

<p>Can anyone support me?</p>

<p>Thanks in advance.</p>
