How do I combine Exel workbooks?

K

Kman

I have 2 Excel workboos that I want to merge or combine into one set of
worksheets. Can this bedone without copying each sheet?
 
Z

Zack Barresse

The only other options I could think of are using formulas (not really
recommended) or programmatically using VBA. Are you adversed to
copy/pasting?
 
S

Spiky

I have 2 Excel workboos that I want to merge or combine into one set of
worksheets. Can this bedone without copying each sheet?
Click to expand...

If you just want all the sheets in their current form, but in one
file....the easiest way is probably drag-n-drop. Have both files open,
and nothing else.

Menu: Window->Arrange->Horizontal (any will work, horizontal will be
easiest to see if there are a lot of sheets)
Then select all the sheets in one file, drag them to the other one. If
they need to be in a certain order, drag them into order. Save.

It will automatically rename any duplicate sheet names with a "(2)" at
the end.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I merge/combine different workbooks with different sheets 2
combine multiple workbooks? overcome 255 character limit? 3
How do I combine five Excel 2003 workbooks? 2
Combine many exel files to one 1
How do I combine worksheets w/o enough rows to combine? 3
List Management Question- Combining into one 2
How can I combine several excel files into one? 1
How to combine or import multiple Excel workbooks? 5

Top