copy data from a specific range to another sheet

[new_to_vba]

i have 2 work sheet, i need to copy the data from a specific range from one work sheet to another sheet..
anyone have any idea how to do that?

[sharon2006]

Hi,

Below are the code u can have a try.
Sheet2 will work as a source file for u to copy.
Sheet1 is the destination.

This code will copy data from column A, range A1 till A10 to sheet 1.


Sub Copy()

Worksheets("Sheet2").Range("A1:A10").Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("A1:A10")
Application.ScreenUpdating = True

End Sub


Regards,
Sharon

[new_to_vba]

hi..thanks sharon for your help..
how to modify the codes to copy a few rows to anoher worksheet?

[sharon2006]

Halo..

U can just repeat the code only like the following example.

Sub Copy1()

Worksheets("Sheet2").Range("A1:A10").Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("A1:A10")


Worksheets("Sheet2").Range("C1:C10").Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("C1:C10")


End Sub



or another way is write the formula into the sheet1( Destination of the data) for auto copying the data

=Sheet2!A1


I have attach the file, u can have a look!

Regards,
Sharon

[new_to_vba]

thanks again sharon
( =