How do I copy data from one Excel sheet to another? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. 开发者_JS百科 Closed 10 years ago.

I need VB code for copying daata from one Excel sheet (sheet1) to another (sheet2). How do I do this?

---

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

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