Producing List Based on Range of Dates

dabrams

New Member
Joined
Nov 20, 2008
Messages
12
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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
ABC
1NameTaskDue
2JoeClean your room12/1/2012
3JoeWash the dishes1/5/2013
4SandyWalk the dog1/1/2013
5BiffTake the day off12/30/2012
6LisaDo laundry12/27/2012
7LisaClean the lint trap12/27/2012
Sheet1
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
Please post small samples of what you have in sheet 1 and what you expect to see in sheet 2 - see How to
 
Upvote 0
DTS

*ABCDEFGHIJ
****
********
*
*
*
*
*
*
*
*
*
*

<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>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="colspan: 6, align: center"]Assignment Log[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]Last updated:[/TD]
[TD="align: left"]06-11-2012[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #ffffcc, align: center"]No.[/TD]
[TD="bgcolor: #ffffcc, align: center"]Discipline[/TD]
[TD="bgcolor: #ffffcc, align: center"]Subject[/TD]
[TD="bgcolor: #ffffcc, align: center"]Responsible[/TD]
[TD="bgcolor: #ffffcc, align: center"]Reference
and date[/TD]
[TD="bgcolor: #ffffcc, align: center"]Date Entered[/TD]
[TD="bgcolor: #ffffcc, align: center"]Contents[/TD]
[TD="bgcolor: #ffffcc, align: center"]Due by[/TD]
[TD="bgcolor: #ffffcc, align: center"]Status[/TD]
[TD="bgcolor: #ffffcc, align: center"]Comments[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Civil[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]George[/TD]
[TD="align: center"]MOM 04.11.2012[/TD]
[TD="align: center"]05.11.12[/TD]
[TD="align: left"]Work Packages[/TD]
[TD="align: center"]30.11.2012[/TD]
[TD="align: center"]Done[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Electrical[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]Jerry[/TD]
[TD="align: center"]MOM 04.12.2012[/TD]
[TD="align: center"]05.12.12[/TD]
[TD="align: left"]Finalizing total ojections answers[/TD]
[TD="align: center"]10.12.2012[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Mechanical[/TD]
[TD="align: center"]General Design[/TD]
[TD="align: center"]Jill[/TD]
[TD="align: center"]MOM 15.11.2012[/TD]
[TD="align: center"]17.11.12[/TD]
[TD="align: left"]Geotechnical sudy following test borings (get date from Frank)
Remark: Depends upon budgeting drilling contactor & laboratories for tests.[/TD]
[TD="align: center"]14.01.2013[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]Comm[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]MOM 15.12.2012[/TD]
[TD="align: center"]18.12.12[/TD]
[TD="align: left"]Submit RFP general first draft for review[/TD]
[TD="align: center"]14.01.2013[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]Plumbing[/TD]
[TD="align: center"]General Design[/TD]
[TD="align: center"]Gregory[/TD]
[TD="align: center"]MOM 04.11.2012[/TD]
[TD="align: center"]05.11.12[/TD]
[TD="align: left"]Work Packages[/TD]
[TD="align: center"]20.11.2012[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]Civil[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]George[/TD]
[TD="align: center"]MOM 04.12.2012[/TD]
[TD="align: center"]05.12.12[/TD]
[TD="align: left"]Finalizing total ojections answers[/TD]
[TD="align: center"]10.12.2012[/TD]
[TD="align: center"]Done[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]Electrical[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]Jerry[/TD]
[TD="align: center"]MOM 15.11.2012[/TD]
[TD="align: center"]17.11.12[/TD]
[TD="align: left"]Geotechnical sudy following test borings (get date from Frank)
Remark: Depends upon budgeting drilling contactor & laboratories for tests.[/TD]
[TD="align: center"]20.11.2012[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]Mechanical[/TD]
[TD="align: center"]General Design[/TD]
[TD="align: center"]Jill[/TD]
[TD="align: center"]MOM 15.12.2012[/TD]
[TD="align: center"]18.12.12[/TD]
[TD="align: left"]Submit RFP general first draft for review[/TD]
[TD="align: center"]22.12.2012[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]Comm[/TD]
[TD="align: center"]RFP[/TD]
[TD="align: center"]William[/TD]
[TD="align: center"]MOM 04.11.2012[/TD]
[TD="align: center"]05.11.12[/TD]
[TD="align: left"]Work Packages[/TD]
[TD="align: center"]14.01.2013[/TD]
[TD="align: center"]Open[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]Plumbing[/TD]
[TD="align: center"]General Design[/TD]
[TD="align: center"]Gregory[/TD]
[TD="align: center"]MOM 04.12.2012[/TD]
[TD="align: center"]05.12.12[/TD]
[TD="align: left"]Finalizing total ojections answers[/TD]
[TD="align: center"]10.12.2012[/TD]
[TD="align: center"]Done[/TD]

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
 
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top