I'll take Ron's idea on step further. Record a macro that when you hit the
submit button, copies the hidden row, pastes it (as values) on the first row
of sheet 2, then in the same place on sheet 2, inserts a row and returns to
the form on sheet 1.

This will allow users to just click a button and you will have the newest
data always at the top of the page on sheet 2.

"DanielWalters6" wrote:

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!