In F2, the number 2; in F6, the number 6, and in F7,
the number 7. Is this normal? What are they related to?

Having taken care of the core bits earlier <g, here's some additional
clarification. Col E in Sheet1 is a helper criteria column which returns
arbitrary row numbers for those rows in Sheet1 which satisfy the "filter"
criteria (i.e. the deadlines which match with the deadline of interest input
in Sheet2's A1) and returns blanks ("") for other rows which don't satisfy.
These numbers: 2, 6, 7, ... etc are then read by the formulas in Sheet2
(from row3 down) to extract rows which satisfy the criteria nicely to the
top over there.

Is there a button to press or pull-down command?

For Sheet2's A1, instead of keying-in the deadline of interest, we could
create a data validation (DV) dropdown to select the date.

Try this:

Insert a new Sheet3
Enter in A1, say: 01-Jun-05
Copy A1 down to A214 to generate sequential dates
all the way to 31-Dec 2005

With A1:A214 selected, click inside the Namebox*, input a name: DateList,
press ENTER (this creates a named range for use in the DV
*the box with the drop arrow just to the left of the formula bar

In Sheet2:
Click Window Unfreeze Panes
(In Excel 97 - my version, DVs above/to the left of frozen panes will not
work. That's the reason for this precaution.)

Select cell A1
Click Data Validation
Under Allow: select "List"
Put in "Source:" box: =DateList
Click OK

Now when you click on A1, there should be a droplist appearing for you to
select the deadline of interest

Here's a revised sample file with implemented DV droplist:
http://flypicture.com/p.cfm?id=67997

(Right-click on the link: "Download File"
at the top in the page, just above the ads)

File: DianeMcP_newusers_2.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----