quick way to combine 2 files?

  • Thread starter Thread starter Lee Harris web
  • Start date Start date
L

Lee Harris web

If you have two excel files, both of which have 3 or 4 worksheets
that are all used in lookup routines etc etc, is there an easy way to
combine the two into a single file, as I think it won't work just by
copying and pasting individual worksheets over in their entirety

tks in advance
LeeH
 
Lee,

With both workbooks open, group the sheets of one workbook (using Ctrl
clicks on the tabs) then right click and select Move or Copy and then
move them into the other workbook.

HTH,
Bernie
MS Excel MVP
 
Back
Top