Producing List Based on Range of Dates

[dabrams]

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.

 

[T. Valko]

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.

Will there be duplicate names with different tasks:

Book1
	A	B	C
1	Name	Task	Due
2	Joe	Clean your room	12/1/2012
3	Joe	Wash the dishes	1/5/2013
4	Sandy	Walk the dog	1/1/2013
5	Biff	Take the day off	12/30/2012
6	Lisa	Do laundry	12/27/2012
7	Lisa	Clean the lint trap	12/27/2012
Sheet1

 

[dabrams]

Hi Biff,
Yes, there will be duplicate names with different tasks as you showed in your table.
Of course there is more information per row item; there's 10 columns of information.

 

[T. Valko]

Hi Biff,
Yes, there will be duplicate names with different tasks as you showed in your table.
Of course there is more information per row item; there's 10 columns of information.

Ok, in that case you'll want to do this with a macro. Unfortunately, I'm not much of a programmer so someone else will need to help with it.

Good luck!

 

[VoG]

Please post small samples of what you have in sheet 1 and what you expect to see in sheet 2 - see How to

 

[dabrams]

DTS

*	A	B	C	D	E	F	G	H	I	J
1	*	*	*	Assignment Log	*
2	*	*	*	*	*	*	*	Last updated:	06-11-2012	*
3	No.	Discipline	Subject	Responsible	Reference and date	Date Entered	Contents	Due by	Status	Comments
4	1	Civil	RFP	George	MOM 04.11.2012	05.11.12	Work Packages	30.11.2012	Done	*
5	2	Electrical	RFP	Jerry	MOM 04.12.2012	05.12.12	Finalizing total ojections answers	10.12.2012	Open	*
6	3	Mechanical	General Design	Jill	MOM 15.11.2012	17.11.12	Geotechnical sudy following test borings (get date from Frank) Remark: Depends upon budgeting drilling contactor & laboratories for tests.	14.01.2013	Open	*
7	4	Comm	RFP	William	MOM 15.12.2012	18.12.12	Submit RFP general first draft for review	14.01.2013	Open	*
8	5	Plumbing	General Design	Gregory	MOM 04.11.2012	05.11.12	Work Packages	20.11.2012	Open	*
9	6	Civil	RFP	George	MOM 04.12.2012	05.12.12	Finalizing total ojections answers	10.12.2012	Done	*
10	7	Electrical	RFP	Jerry	MOM 15.11.2012	17.11.12	Geotechnical sudy following test borings (get date from Frank) Remark: Depends upon budgeting drilling contactor & laboratories for tests.	20.11.2012	Open	*
11	8	Mechanical	General Design	Jill	MOM 15.12.2012	18.12.12	Submit RFP general first draft for review	22.12.2012	Open	*
12	9	Comm	RFP	William	MOM 04.11.2012	05.11.12	Work Packages	14.01.2013	Open	*
13	10	Plumbing	General Design	Gregory	MOM 04.12.2012	05.12.12	Finalizing total ojections answers	10.12.2012	Done	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:34px;"><col style="width:71px;"><col style="width:96px;"><col style="width:101px;"><col style="width:105px;"><col style="width:105px;"><col style="width:335px;"><col style="width:96px;"><col style="width:96px;"><col style="width:195px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4