How to set up a column to accept changing data from 1 cell on ano.
 

I have a form set up on one sheet of a workbook and need the data which is
entered to go to another sheet. I get it to take one entry but when I enter
new data it replaces what was there on the other sheet instead of going to
the next line.

Easier to correct partially working code than trying to guess what you are
doing. Post your code. Tell us where it is located.

--
Regards,
Tom Ogilvy

"hdismang" wrote in message
...
I have a form set up on one sheet of a workbook and need the data which is
entered to go to another sheet. I get it to take one entry but when I
enter
new data it replaces what was there on the other sheet instead of going to
the next line.