Nick Hodge
12/19/2006 3:28:00 PM
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
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk
"Anna" <colleen1980@gmail.com> wrote in message
news:1166541465.296086.149420@80g2000cwy.googlegroups.com...
> Hi: Can any one please tell me how to i copy data from one file sheet
> into another file sheet?
>
> Thanks.
>