Best option to have users from multiple separate Excel files upload their completed rows to a Final workbook

[mssbass]

I have tried sharing an Excel file but there are too many errors. I'd like to have the users upload their data on their individual workbooks to a final workbook. Once they finish entering data on a row (record), is it possible for them to click a button and upload that record to the final file (on the next row)? Each record has a primary key field. If they make a mistake and wish to overwrite that prior upload, is that possible? Once the button is clicked and the record has been uploaded successfully, I'd like the row to show uploaded (possibly a field marked yes at the end of the row). suggestions???

 

[Logit]

Basically each user will be performing a COPY / PASTE method from their workbook to the Main Workbook.

Main restriction is only one person at a time can access the Main Workbook.

There are plenty of examples on the internet and this / other Forums demonstrating how to do what you are seeking.

Search for ; COPY PASTE between workbooks; pasting to first empty row; checking for duplicate rows; edit existing row data.

 

[mssbass]

So when they click the button to upload and someone else is uploading (copy/pasting) at that time, will they receive a lock-out error or will it just wait...

 

[Logit]

They will receive a notice the Main Workbook is in use / not accessible.

I've seen macros that can be customized advising the individual the workbook is in use. They will simply have to wait and try late.