You should use the advanced filter to create separate ranges of data that
match your criteria, and then link the listbox to these ranges.

--
HTH

Bob Phillips

"Lizzie_S" wrote in message
...
Hi Everyone,

In my spreadsheet, I have the following choices in G4 to G54.
Not Started
In Progress
Completed

And from H4 to H54, It contains the date when the tasks should be
completed.
e.g. 7/27/2005
8/15/2005

From C4 to C54, I have a list of tasks.


I have added a form and 2 listboxes. On the first listbox, i want to show
all the tasks overdue, and on the 2nd listbox i want to show all the tasks
that are still on schedule. And i dont know how to do it.

To determine if the task is overdue, the status is not started, in
progress
and exceeds to the date of completion otherwise it should fall on
listbox2.


Please help.

Thanks in advance