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.
 
Back
Top