title: Macro for project list. need to copy and paste data from one sheet to the next based on the entry of a completion date
body: <p>I want to enter a completion date in row a on sheet "Master Project List" and have Excel copy that row and paste the data on a separate sheet named "completed projects". </p>
  
  <p>How can I tell Excel to copy and then paste a row of data to a separate sheet based on the completion date listed in row a? </p>