Cut & Paste cells into another sheet with cell change

  • Thread starter Thread starter Manda
  • Start date Start date
M

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
 
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
 
Back
Top