ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy information (https://www.excelbanter.com/excel-discussion-misc-queries/151988-copy-information.html)

Chi

copy information
 
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


bj

copy information
 
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

"Chi" wrote:

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



All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com