Cut & Paste cells into another sheet with cell change
 

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

Cut & Paste cells into another sheet with cell change
 

Why dont you try the Data|Filter option
--
If this post helps click Yes
---------------
Jacob Skaria


"Manda" wrote:

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

Cut & Paste cells into another sheet with cell change
 

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

"Jacob Skaria" wrote:

Why dont you try the Data|Filter option
--
If this post helps click Yes
---------------
Jacob Skaria


"Manda" wrote:

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

Cut & Paste cells into another sheet with cell change
 

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
---------------
Jacob Skaria


"Manda" wrote:

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

"Jacob Skaria" wrote:

Why dont you try the Data|Filter option
--
If this post helps click Yes
---------------
Jacob Skaria


"Manda" wrote:

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

Cut & Paste cells into another sheet with cell change
 

What would the macro have to say?

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Manda" wrote:

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

"Jacob Skaria" wrote:

Why dont you try the Data|Filter option
--
If this post helps click Yes
---------------
Jacob Skaria


"Manda" wrote:

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