I have a spreadsheet with jobs in coulmn "A", a description in column "B",
and a status of Open or Complete in column "C". I need to have the jobs that
are complete moved (cut & pasted) onto sheet two. Is there a function that
will automatically cut and paste the information when I enter "complete" into
column "C"? Once a job is complete I no longer want to see it on sheet one.

Here is an example of sheet one...

JOB DESCR STATUS
1 clean open
2 blast complete
3 wash open
4 paint open
5 wash open
6 paint complete

Thank you for your help!
Manda