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.