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

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
"Fahad Sadiq" <Fahad wrote in message
...
how i can merge more than two excel files in one file.

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