Create a data entry form.

Hi,

I'm looking a create a data entry form whereby the user enters values in cells within a column and clicks submit. Then the values are pasted to corresponding columns and the values in the data entry cells are cleared. Every time the data in the data entry cells is entered the values are posted to the next row down.

I have attached a sample worksheet with annotation.

Cheers
GC

Very basic code but written to be easy to ready and develop as we have no idea from your post of your level of ability with VBA.
Paste the below into a standard module and attach the macro to your 'submit' button.

Please Login or Register  to view this content.

BSB

As a beginner starter via Excel basics :

PHP Code: 

Sub Demo1()
    Cells(Rows.Count, 4).End(xlUp)(2).Resize(, 33).Value2 = Application.Index([B2:B34], [COLUMN(A:AG)])
    [B2:B34].ClearContents
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Cheers all,

Works a treat.

GC