View Full Version : Copy 2 sheet from 1 workbook to another workbook

03-24-2012, 07:21 AM
I have 2 workbook . with names WorkBook1 and Workbook2

I have some data in sheet 4 and 5 of workBook1 and want to copy them to sheet 1 and 2 of Workbook2 and also for others also copy to latest blank row of sheet 1 and 2 of Workbook2.

The range of data will be from A to E column .

Please help me with VBA code .

Thank you so much .