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.