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

O

Otto Moehrbach

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
 
C

Chris Rogers

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?
 
C

Chris Rogers

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
 

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

Merging from an Excel file with graphics 1
How to create a bubble chart with more than 2 variables. 0
Width of document changes when merging 1
Merge Excel file into Word Document 3
Mail Merge Directory Conditional Page Break 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Mail Merge skipping records/sending one at a time 0

Top