title: Excel - move a whole row into the next worksheet if cell contains specific text
body: <p>I am trying to set up a formula where worksheet 1 is a list of install jobs for the month, there are several columns showing customers details and at the last column showing the progress of the job from a drop down list.</p>
  <p>If the job is &quot;completed&quot; then I would like the entire row to be copied into the next worksheet (worksheet 2) and if the job is in progress then it does not go onto the next worksheet.</p>
  <p>i also have several failed reasons would it be possible to have a this data transferred to (worksheet 3) to show a list of filed jobs from sheet 1</p>