submit / update macro

[ElBenno]

Hi,
I am trying to create 2 work sheets. One is just a simple table (register). The other I want to be able to use as a sort of Form where i can enter data into the cells and then click a submit / update button that will then populate the register. Can anyone help with this macro or VBA.

Kindest Regards,

ben

 

[agihcam]

how was the two sheets laid out?

 

[ElBenno]

My register is a normal table:

Date Identification method Details Names Involved


Then the other sheet i want to be like a form that runs down the page:

Date:_______________

Identification Method: <<A boxed cell / field here for text>>

Does that help??

 

[agihcam]

you can start with this code;

Private Sub CommandButton1_Click()
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheets("form").Range("a1")
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(, 1) = Sheets("form").Range("a3")
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(, 2) = Sheets("form").Range("a5")
End Sub