Look through each sheet and copy and paste to another workbook

Closed
Wen - Dec 25, 2014 at 07:51 AM
Hello,

Dear Sir

Would you know how to copy from row 2 to row 20,000 in sheet 1 to sheet 10 in one workbook and paste to corresponding sheet 1 to sheet 10 in another workbook. and look through each sheet if there is no data between row 2 to row 20,000 then go to next sheet to copy and paste.

Thank you.