merging workbooks?

M

Mark1

Is there a way to merge workbooks together without having to copy the pages
from one into another? All I want to do is add the pages from one to the
other. So that in one workbook I have page A, B, and C. Then in the other I
have D, E and F. I now want to have one workbook with A,B,C,D,E and F.
Thanks!
 
A

Arvi Laanemets

Hi

Open both workbooks. Activate one of them, and select all tabs (click on
leftmost tab, hold Shift down and click on rightmost one). Richt-click on
selected tabs ans select 'Move or copy' from dropdown list. In 'To book'
field select the other workbook. When you want leave sheets in old/source
workbook too, then check 'Create a copy' (or simply close source workbook
afterwards without saving). Press OK. When needed, rename moved sheets.
Save the target workbook.
 
M

Mark1

That's what I've been doing, but I have so many pages that the clipboard gets
full and I get all kinds of weird numbers in the copied sheets. I was
wondering if there were another way.
 
Top