Response to OP's additional criteria request:

---------------
Leah,

Pl follow up in the newsgroup thread, not via private email.

You could enhance the criteria this way, in C2, copied down:
=IF(COUNT(A$2:A$3)<2,"",IF(AND(Sheet1!A2=A$2,Shee t1!A2<=A$3,OR(Sheet1!D2={"AA","AT"})),ROW(),""))

Max
----- Original Message ----
From: Leah Davis
To: Max
Sent: Monday, February 9, 2009 7:01:04 PM
Subject: Transfer certain data from Sheet 1 to sheet 2

Hi Max,

Thanks very much for this. It is the formula I have been looking for. I have
one addition I need to make to finish off the spreadsheet. Column D on
sheet1 contains a list which offers the following choice of data:

AA
AT
IX
CD
IA

The data I need copied to sheet 2 has the date criteria you have already
plus must only include rows which have either AA or AT in column D. I am not
quite sure how to modify the formula you provided to do this.

I thought it could be
=IF(COUNT(A$2:A$3)<2,"",IF(AND(Sheet1!A2=A$2,Shee t1!A2<=A$3,
Sheet1!D2="A*"),ROW(),"")) but this doesn't work. Would appreciate if you
could help with this.

Thanks.