How do I combine Exel workbooks?

  • Thread starter Thread starter Kman
  • Start date Start date
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?
 
The only other options I could think of are using formulas (not really
recommended) or programmatically using VBA. Are you adversed to
copy/pasting?
 
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
merging data/worksheets 1
macrio soft exel 2
Combine many exel files to one 1
Function to link workbooks problem 1
combine multiple workbooks? overcome 255 character limit? 3
How do I combine worksheets w/o enough rows to combine? 3
How to I combine excel worksheets? 6

Back
Top