Thankyou for your help :)


--
iPod's ROCK!


"Ron de Bruin" wrote:

Hi

Look here
http://www.rondebruin.nl/copy1.htm

Use a row on the bottom of your form( you can hide that row)
Add formula links (=c3) to the cells you want in that row and use this
range to copy to sheet 2

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


"DanielWalters6" wrote in message
...
I would like to be able to create a FORM on say sheet one. I would like to
have about ten fields on the form

I would like to then have a SUBMIT button which takes the data from the
field and enters it into say sheet two. (Each column being a different field
and each row being a seperate record.)

Am able to do this in Access2003, but haven't used Excel for anything other
than simple finances up-to-date.

Hope you can help

Daniel


--
iPod's ROCK!