Macro to copy from One File to another

[seenai]

Hi
I need a macro to copy data from one file to another.

eg : from Workbook A, Sheet Name : Data1 (Range : Entire Sheet)
copy to Workbook B, Sheet Name : Data1
&
from Workbook A, Sheet Name : Data2 (Range : Entire Sheet)
copy to Workbook B, Sheet Name : Data2



Thanks in advance.

B.Srinivasa Rao

 

[JackDanIce]

Try recording a macro to:

- Delete sheet Data1 from Workbook B
- Copy sheet Data1 from Workbook A into Workbook B

Repeat for Data2

Try that and post the code if any issues or changes required.