Hello,

I have two excel file that is abc.xls and xyz.xls.
Both file contain 3 worksheet with the same name (sheet1, sheet2 and sheet3) and heading.
I am trying to copy the data of sheet1 of abc.xls to sheet1 of xyz.xls
Sheet1 of XYZ.xls also has some data. So, abc.xls data will copy after that.
How to do it through macro.

Thanks....