Copying Range DAta from One Excel Workbook to Another

Jignesh · May 13th, 2002, 12:38 AM

Hi
I need to copy range data from an excel sheet to an excel sheet in Master Workbook.Can u please tell me code to do that??
Thanks in advance.......

Jignesh

Juan Pablo González · May 13th, 2002, 12:49 AM

Code for that...

Workbooks("Book1.xls").Sheets("Sheet1").Range("A1").Copy Workbooks("Book2.xls").Sheets("Sheet2").Range("B2")

How's that ?

May 13th, 2002, 12:49 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Code for that... Workbooks("Book1.xls").Sheets("Sheet1").Range("A1").Copy Workbooks("Book2.xls").Sheets("Sheet2").Range("B2") How's that ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 12:38 AM	#1
Jignesh New Member Join Date: May 2002 Posts: 6	Hi I need to copy range data from an excel sheet to an excel sheet in Master Workbook.Can u please tell me code to do that?? Thanks in advance....... Jignesh