Cut & Paste cells into another sheet with cell change

[Manda]

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

 

[Jacob Skaria]

Why dont you try the Data|Filter option

 

[Manda]

I would do that but I really would like for the completed jobs to be on a
separate sheet.

 

[Jacob Skaria]

Filter and then cut and paste to the next sheet..

OR

other wise you will have to use a macro to do this automatically whenever
you open or save the workbook

If this post helps click Yes