macro for copy data Workbook1 and paste to Workbook2

Originally Posted by santosh226001

i m copying ur code in book1 is it ok?

yeah, right
to take into account all possible errors in the files, one need to write a branched error handler in the code. This will increase the code multiple times. Therefore it will be better if you attach the sample files Book1 and Book2
Edited
Oh, I am writing in English for too long