| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do dates change when I copy/paste into another sheet? | Excel Discussion (Misc queries) | |||
| Formula copy paste down in a sheet but change row letter increment | Excel Discussion (Misc queries) | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| How do I change excel sheet from R1C1 for cells to A1 for cell? | Excel Worksheet Functions | |||
| Change macro to paste as last sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
