On sheet1 I have a continually updating list. A:A contains dates, B:B
and C:C contain ID numbers. Some dates will be duplicated and some ID
numbers will be duplicated. On sheet2 I have a calendar and date box.
When the user enters a date into sheet2!B1 I need a5:c? to generate all
the lines from sheet1 that have the same date.
For example:
sheet2!B1 = 6/1/06, sheet2!a5 should say 6/1/06, sheet2!b5 should say
1234 and sheet2!c5 should say 9876. This should repeat all the way
down until there are no more dates on sheet1 that match sheet2!b1.

I hope this makes sense. Please let me know if I need to elaborate or
show a detailed example. Thanks.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=549232