Listing Data According to Overdue Dates

**dabrams** · 12-30-2012, 10:10 AM

I know this will be too easy too answer for you gurus.
The table I manage contains assignments for various people, and a due date for each assignment (different assignment per row).
My boss wants a separate list of all assignments that are overdue (every week he wants an updated list).
I'd prefer that this list appear in a different work sheet.
The list should not have blank rows, and be able to be sorted by name.
If you know some of some macro that would do this, that would be great.
Formulas would also be fine.
thanks, you guys, you are great.

**jeffreybrown** · 12-30-2012, 10:31 AM

Hello & Welcome to the Forum,

IMO, the easiest solution, add a column which will identify whether or not that row is "Overdue"

=IF(E2<TODAY(),"Overdue","") >> E2 = 12/22/2012 >> so this row would show overdue

Now filter on that column for "Overdue" and you have you list

EDIT: If you don't want to use the filter, see this attachment which used one small macro attached to a button.