Hello Everbody,

I need to make a button that copies data from a fillable user form (not a "UserForm") on a spreadsheet and paste it to my database tab in a column format. The code would need to:

-check if the record already exists
-if it does exist on the database tab, ask user to overwrite (yes/no message box)
-if it does not exist then paste all data to the database tab on a new row (one row is one record)

I know how to make a button to clear all entered data, so I would also like to make a button to recall a previous record from the database tab and populate it to the user form.

Please refer to the attached document to see my first table and tab set up. There are 3 more tables totaling 300 columns in the database tab , but I should hopefully be able to apply the code to them as well.

Form With Database.xlsx

So I have my fillable user form (which has to be usable when printed, hence the format), and my database tab has links to the headers of the form. I'm assuming you need some kind of ID tag for each record, but I'm not too sure how to do it.

Any ideas?