Copy Data to latest row of other sheet

[parscon]

I need a help .

i want copy my data to latest row on other sheet row .

I have a Sheet A and Sheet B in Sheet B i have data on row 1-2-3
and now in sheet A i have a data and want copy it to sheet B and it will be place on latest row that mean row 4 on sheet B . (i want to find the latest empty row on second sheet and paste data on it .)

Could you please price me VBA code for this ?


THank you so much .

[Kenneth Hobs]

Worksheets("Sheet1").Range("A1").Copy _
Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
Application.CutCopyMode = False