Need VB code for copying data from an excel sheet to another excel sheet in "sheet2"bcoz I already have data in "sheet1" tab.

Question

I need a VB code for the above question.Please help.

Answer 1

This will copy everything from the first worksheet to the second:

Sub Test()
    Worksheets("Sheet1").UsedRange.Copy
    Worksheets("Sheet2").Range("A1").PasteSpecial
End Sub