Copying Range DAta from One Excel Workbook to Another

[Jignesh]

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]

Code for that...

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

How's that ?