title: Formula for copying whole row and pasting to sheet2 base on a condition
body: <p>I have a database for all the "active" files in the office.  I always had to copy and paste the whole row and pasting it on a different sheet when the case becomes inactive or placed in storage,.</p>
  
  <p>Is there a formula where I can add the formula: If I add the word "Storage" on AJ then excel will copy the sheet1 A1 row and paste it on sheet 2 wherever it's has the next available row open. </p>