Autopopulate text to 2 worksheets with different formats

[Dave32]

Currently, I have 3 worksheets: DataEntry1, Autofillform2, Database

I am using a VBA script (provided by Roy) to autopopulate text from DataEntry to Database. One row for each record.

Now I need to amend the code so that when you click on "Save Record" some text is also autopopulated to the worksheet "Autofillform2"

The fields I need autopopulated are in yellow.

Can anyone amend the exisiting code? you don't need to add code for all the fields but just put etc.. so I get the idea of how the code is working.

Also is it possible to check for duplicate entries? field "Unique Identifier".

Code is below and spreadsheet is attached.

Thanks,

Dave32

Private Sub CommandButton1_Click()
Dim R As Long
With Sheet2
R = .Cells(.Rows.Count, 1).End(xlUp).Row + 1
.Cells(R, 1).Value = Sheet1.Cells(3, 2).Value 'ID
.Cells(R, 2).Value = Sheet1.Cells(4, 2).Value 'Campaign Name
.Cells(R, 3).Value = Sheet1.Cells(5, 2).Value 'Region
.Cells(R, 4).Value = Sheet1.Cells(6, 2).Value 'Country
.Cells(R, 5).Value = Sheet1.Cells(7, 2).Value 'Product Focus

'etc

End With
End Sub

Private Sub CommandButton2_Click()
Range("B3:B13,B17:B28,D5:D7").ClearContents
End Sub

[royUK]

Please read the Forum Rules & use code Tags in future

[royUK]

Why are you entering into the new sheet as well?

[Dave32]

Roy,

Thanks for your reply the two dataentry sheets are examples. Basically, I have two different data entry sheets which represent marketing info. from two different companies. My company and my customer. Each company has it own processes etc...

So I cannot use one dataentry form for the same thing(record). Both forms have their own format/look and feel and will never look the same but will contain similiar data.

Once these forms have been filled in they will get sent individually to different people. I will then have the info from both forms in the "database" worksheet. There will probably also be some additional info in the second data entry form which I need to get into the database as well.

Sorry this is so complicated...

Thanks Dave32