Try this if I understand you correct
http://www.rondebruin.nl/copy1.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Joseph Cura" wrote in message . ..
I amsomewhat of a novice with Excel.
I have created a form and a macro to print then clear the form. What I am
trying to do is to take certain cells in this form and copy them into a
report.How do I get the data which will change each time the form is filled
to paste into the report going down the column.