Exporting data from an excel worksheet to a masterfile.

Are you talking about a UserForm or a sheet designed as a form?

To get the next row you need to use something like

Dim R as Long
'this will get the Row number
R=Sheet1.Cells(Rows.Count,1).End(xlUp).Row +1

Or

'this will be the next empty cell in ColumnA
Sheet1.Cells(Rows.Count,1).End(xlUp).Offseet(1,0)

Thanks for the info regarding next available cell, the way i design forms is to designa a worksheet as a form with macros to handle validation and saving.

I guess the reason I'm posting here is to look for better ways than what I already use.

I'm still now sure how to overcome the problem of multiple users using the form at the sametime, if 2 people open the form at the same time and save it, they're both going to attempt to write the same row, how can this be overcome?

The workbook is going to have to be opened as a shared workbook to allow people to use it simultaneously, in my experience once the workbook is open it is static, it isnt updated with changes from other users, is it possible to refresh the workbook with changes from other people just Before saving?

You will get errors iof you are trying to allow multiple users to write to the sheet, maybe you should consider Access for this.