Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SORTING TO ANOTHER SHEET
CAN SOMEONE HELP
HERE IS MY DATA A B C D Name CofC Date FDA OTMR B------ PHIL 17-Aug-06 17-Feb-06 17-Aug-06 COMPLETED 10-Jan-06 15-Jan-06 B------- BOB 30-Aug-06 28-Feb-06 30-Aug-06 COMPLETED B----- Steve 05-Mar-06 05-Sep-06 05-Mar-06 COMPLETED B----- Dave 14-Dec-06 14-Jun-06 14-Dec-06 COMPLETED B----------- Wayne 10-Mar-06 10-Sep-06 10-Mar-06 COMPLETED and so on column c and d are activities the person has to complete and the date under this is the latest it has to be completed, along the completed rows are the dates they were completed. What i have it doing using cond format is background goes black of the cell if within 60 days and yellow if it has a completed date in. what i am after on a seperate sheet is a list of all that are within 60 days and not been completed like this B------- BOB 28-Feb-06 FDA B----- Steve 05-Mar-06 OTMR PLEASE HELP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SORTING TO ANOTHER SHEET
cityfc,
do you have many columns or only the three (CofC, FDA, OTMR)? wAyne "cityfc" wrote: CAN SOMEONE HELP HERE IS MY DATA A B C D Name CofC Date FDA OTMR B------ PHIL 17-Aug-06 17-Feb-06 17-Aug-06 COMPLETED 10-Jan-06 15-Jan-06 B------- BOB 30-Aug-06 28-Feb-06 30-Aug-06 COMPLETED B----- Steve 05-Mar-06 05-Sep-06 05-Mar-06 COMPLETED B----- Dave 14-Dec-06 14-Jun-06 14-Dec-06 COMPLETED B----------- Wayne 10-Mar-06 10-Sep-06 10-Mar-06 COMPLETED and so on column c and d are activities the person has to complete and the date under this is the latest it has to be completed, along the completed rows are the dates they were completed. What i have it doing using cond format is background goes black of the cell if within 60 days and yellow if it has a completed date in. what i am after on a seperate sheet is a list of all that are within 60 days and not been completed like this B------- BOB 28-Feb-06 FDA B----- Steve 05-Mar-06 OTMR PLEASE HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions |