Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to merge 2 excel files in 1 file ?

Status
Not open for further replies.

pepmarti

Programmer
Apr 2, 2001
31
ES
I need to merge 2 excel files in only 1 file.
With excel or other external program.
The columns are the same.
Thanks
 
Right click on the sheet tab, usually located at the bottom of the screen, and select "Move or Copy"

In the "To book :" pulldown, select the alternate file.

Not hard at all !
 
I want to copy the files
a.xls + b.xls to c.xls
I don't know the number of rows.
The best solution is a external program but
i don't know if exit this program, thanks for all.
 
Open files a.xls and b.xls
Highlight all rows in a.xls and press Ctrl+C
Window to b.xls, go to last row in the sheet.
Press Ctrl+V to paste
Save file as c.xls

Am I missing something here ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top