| 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 |
| 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) | |||
Threaded Mode
