how i can merge more than two excel files in one file.

  • Thread starter Thread starter Guest
  • Start date Start date
Do you want to bring whole sheets from other files into one file? Or do you
want to copy the contents of the sheets into one sheet on the one file? HTH
Otto
 
Are the files in the same format - i.e. do the hold the same fields in
the same order, or do they contain different information - is there a
field that could function as a key such as customer number or something
like that?
 
If there are sheets that you want in File A, but they are in File B,
try this:

Open both files.

Select all the sheets that are File B (hold down the Ctrl key while
selecting the tabs) then right click and select 'Move or copy'...select
File A in the To book: dropdown.

If you have Create a Copy checked off at the bottom, it will copy those
sheets you selected. If Create a Copy is NOT checked off at the bottom
of the dialog box, it will MOVE the sheets you selected to File A from
file B.

HTH
 
Back
Top