VBA to copy a range to another sheet

[Kiwi den]

Looking for VBA code
Start with deleting data in Sheet1 A1 - E1, so I can enter new data
Then I want to copy a range from sheet1 (A1 - E1) to sheet2 starting in A1 - E1,
then when data in sheet 1 changes, it copies to sheet2 in the next available row

Thanks in advance

 

[Kiwi den]

I now have it so the info copies, but it pastes to column A only on sheet 2 A2 through to A20, rather than across rows A1 to S1

 

[Kiwi den]

Sorry

 

[Logit]

Sub CpyPste()
    Sheets("Sheet1").Range("A1:S1").Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

 

[Kiwi den]

Sub CpyPste()
    Sheets("Sheet1").Range("A1:S1").Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

Got it ,,, Thank you so much, I really appreciate it

 

[Logit]

You are welcome.