JR,

I am doing something similar (user pushes a "submit" button on a form to
enter data into a worksheet). Results of calculations using this data are
shown in the same form. Problem I have is if the user enters data and hits
the submit button multiple times, data will be entered over and over again
into the worksheet designated. Is there a way to avoid this?

"JR" wrote:

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!