The information below is a layout similar to what I have in Sheet Y (these
lines cover 6 rows). I need to print this "form" as many times as the
number of matching rows I have in sheet X with the selected sheet X data in
the proper "blanks" of the form. I would like to enter the date range (or
maybe another criteria) and then have the data placed on the blank forms.
If I need to use what you have below to get my needed rows extracted, I
will. Then I need to replicate the form to allow for each row to be a new
form. If this calls for a macro, a suggestion of where to begin may be what
I need. Thanks again for your help.


Row 1 Date Selection:_______ to_______

Row 2 Form Title

Row 3 Order No:__________

Row 4 Order Date:_________

Row 5 Name:_____________

Row 6 ID:________________



"Max" wrote in message
...
I'm not sure what is still outstanding in sheet: Y.
Could you elaborate ?
Perhaps paste some sample data in plain text in reply here
to illustrate what you have / you are after
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MP" wrote in message
...
Thanks for the quick reply. I didn't explain enough, that my second
sheet (sheet Y) needs the data from Sheet X to be in the proper fields,
that are in multiple rows. Sheet Y is a Form of sorts, and I want to
copy these rows (as a whole form) as far down as I need to accomodate for
all the rows gathered in your formulas below.