Exporting data from an excel worksheet to a masterfile.

Is the UserForm in the master file?

Why don't you have the form in the master workbook? It would be muchh simpler.

You will need to open the masterfile, presumably on a server then write to the sheet. Use the Macro Recorder to record opening this file to get the correct path.

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

To get the next row you need to use something like

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

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.