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
 
You must log in or register to reply here.

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

Combining data from multiple worksheets into one 4
Cannot copy worksheet to another file 2
Counting multiple memberships 1
How to combine two different excel files 1
combining data from several excel files into one file 3
How to combine 200 spreadsheets 5
multiple worksheets 1
Trying to combine 2 Worksheets 1

Back
Top