Entering new data into new row

[wesley]

Hi all,

First post so please be kind.

My problem has two part but same issue.

Workbook has 3 sheets; sheet one has the data details of people coming into accommodation. Data is entered when submit is clicked in a user form and desplayed on the work sheet. Problem - if I add anohter entry via the user form clicking submit the first one is over written only leaving the latest entry regardless of the amount of entry completed.

The next problem is the VB code to move the complete entry row in sheet one to sheet 3 when drop down option X is selected. The row will move from sheet one to three but will write over the existing entry - same problem as above - code below

Please Login or Register  to view this content.

Any help would be appreciated

Thanks.

[teylyn]

Hello and welcome to the forum.

Please take a moment to read the forum rules. I'll move this to the Excel Programming forum, since it has nothing to do with charting.

I'll also add code tags for you, but this time only. Please make sure to use them from now on when posting code.

cheers

[wesley]

Thanks you and sorry, have been very flustered with the code and didn't think to read the rules : (

[wesley]

Bump bump bump