How to copy all data from sheet1 to an existing sheet2 in a workbook using a macro

[jonam25]

Hi All,

I am a rookie in VBA programming. Need help to copy all data from sheet1 to an existing sheet2 in a workbook using a macro.

 

[Smitty]

Welcome to the Board!

Have you tried recording a macro? If you post back what you get someone can explain what the code is doing, and how to clean it up so it's more efficient.

 

[John Davis]

Hi All,

I am a rookie in VBA programming. Need help to copy all data from sheet1 to an existing sheet2 in a workbook using a macro.

Maybe:

Sub jonam25()

Dim lr As Long

lr = Cells(Rows.Count, 1).End(xlUp).Row

Sheets("Sheet1").Range("A1:A" & lr).EntireRow.Copy Sheets("Sheet2").Range("A1")


End Sub

 

[jonam25]

Thanks John. It worked.!!

 

[John Davis]

Thanks John. It worked.!!

You're welcome. Thanks for the feedback, and I'm glad it worked out for you.