copy information

C

Chi

Hi,

I would like to know how to copy information from the workbook B to the
workbook A.

These two workbooks are formatted the same, except the B workbook has
information and the A is empty.

The only way that I am using is copy and past. However, it takes a lot of
time to do it since the workbook has 12 tab sheets.

Please help
Chi
 
B

bj

depending on what is in them you might be able to go to book B select all of
the sheets to be copied and edit-move copy sheet- select copy and select to
Book A
 
Top