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