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

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