Copy data from one file sheet into another
 

Hi: Can any one please tell me how to i copy data from one file sheet
into another file sheet?

Thanks.

Copy data from one file sheet into another
 

Anna

Do you mean another workbook, or another worksheet? Below is the answer to
both, bearing in mind the named references of worksheets and workbooks

Sub CopyToAnotherSheet()
Worksheets("Sheet1").Range("A1").Copy
Destination:=Worksheets("Sheet2").Range("A1")
End Sub

Sub CopyToAnotherWorkbook()
Dim wb1 As Workbook
Dim wb2 As Workbook
Set wb1 = ActiveWorkbook
Set wb2 = Workbooks("Book2")
wb1.Worksheets("Sheet1").Range("A1").Copy
Destination:=wb2.Worksheets("Sheet2").Range("A1")
End Sub



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Anna" wrote in message
ups.com...
Hi: Can any one please tell me how to i copy data from one file sheet
into another file sheet?

Thanks.