parscon
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 .
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 .