automatically move row to another worksheet
 

I would like to automatically move an entire row of a worksheet to another
worksheet when a specified cell is filled in. For example, when the final
date in a row is filled in, I'd the the row to automatically move to another
worksheet in the same Excel file. (I have two worksheets; one named Active,
the named Complete)