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?


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=498589

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


--
sharon2006
------------------------------------------------------------------------
sharon2006's Profile: http://www.excelforum.com/member.php...o&userid=30173
View this thread: http://www.excelforum.com/showthread...hreadid=498589

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

--
new_to_vb
-----------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...fo&userid=3013
View this thread: http://www.excelforum.com/showthread.php?threadid=49858

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:)


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4190 |
+-------------------------------------------------------------------+

--
sharon2006
------------------------------------------------------------------------
sharon2006's Profile: http://www.excelforum.com/member.php...o&userid=30173
View this thread: http://www.excelforum.com/showthread...hreadid=498589

thanks again sharon
( =


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=498589