how to copy data using add button

[isaac]

Plz help me.
i recently need to copy data from user to second row if add button click.

[bhavesh78]

What data does user want to copy. Following copies row 1 to row 2. You can change code to suit ur needs.

~BS

[code]

Sub CommandButton1_Click()
Rows("1:1").Select
Selection.Copy
Range("A2").Select
ActiveSheet.Paste
Range("A3").Select
End Sub

[\code]