One way ..

Source data assumed in sheet: X,
cols A to D, data from row2 down, viz:

Order# Name ID Date
1111 Nam1 ID1 Date1
1112 Nam2 ID2 Date2
1111 Nam3 ID3 Date3
1113 Nam4 ID4 Date4
1112 Nam5 ID5 Date5
etc

Then in another sheet: Y,
Labels placed in C1:E1 : Name, ID, Date

In A2 will be input the order# of interest, eg: 1112

Put in B2:
=IF($A$2="","",IF(X!A2=$A$2,ROW(),""))
Leave B1 blank

Put in C2:
=IF(ROW(A1)COUNT($B:$B),"",INDEX(X!B:B,SMALL($B:$ B,ROW(A1))))
Copy C2 to E2. Select B2:E2, copy down to cover the max expected extent of
data in X, eg to E100. Hide away col B. Format col E as dates. Cols C to E
will return all the lines for the order# in A2 from X, neatly bunched at the
top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark Philley" wrote in message
...
I need advice on retrieving all rows of data that match a specific criteria
or criteria range (ie date(s)) and have the data from these rows copied to
a preformatted worksheet and copied down as many times as the number of
selected rows. Vague enough? In my first sheet I have: Order #, Name, ID,
Date, etc.. My second sheet is a pre-formatted sheet with blanks for all
of the data contained in the first sheet. I want to enter a date or order
# range on the second sheet and have this pre-formatted sheet copied down
the sheet as many times as the no of matching rows I have. (similar to
mail-merging the matching rows to my excel form).