combine worksheets from 2 excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone know how to take 2 excel files and combine all worksheets into one file. i.e. 3 worksheets in one, 3 in another, all with complex formulas (relating only to other cells in that worksheet). How do I convert to a single file

Thank

anan
 
Open both WBs.

Select (group) all 3 sheets of one of the WBs and right click in the tabs.
Choose "Move or Copy",
And expand the "To Book" box and click on the name of the other WB.
Then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Anyone know how to take 2 excel files and combine all worksheets into one
file. i.e. 3 worksheets in one, 3 in another, all with complex formulas
(relating only to other cells in that worksheet). How do I convert to a
single file?

Thanks

anand
 
Open both workbooks.

Select all the sheets in one and Edit|move or copy sheet (move is ok)
and move them to the first workbook.

Save it with a new name.

(If there were worksheets with the same names, you might want to rename the
"(1)" version.)
 
Back
Top