title: Deleting cells based on conditions
body: <p>I have a list of employees in column A, and their status (chosen from a dropdown menu, "Active" or "Inactive") in column B. They are in a sheet called "Employee List".</p>
  
  <p>When an employee's status is set to "Inactive", I want to cut and paste the employee to another sheet automatically. The other sheet is called "Misc"</p>
  
  <p>If this cannot be done automatically when the status is set to "Inactive", then maybe I can set a button that would invoke the VBA commands in that worksheet to clear all inactive employees from the list and move them to the other sheet.</p>