Merging data from 2 data excel sheets

[Joe]

Hi,

I have two excel workbooks. Both of them contain about 5000 rows and have
identical columns. I need to merge these 2 excel sheets into one.
Unfortunately Shared Workbook option wasn't used. Is there any way I can
merge the data from these 2 excel sheets.

Thanks,

Joe Green

 

[Bob I]

Copy, Paste?

 

[Joe]

May be I didn't explain my problem well. Say student ID, SAT scores GMAT
scorres are 3 columns in both the files. Data in Student ID column in both
the files is same. Here is how the files look like

File 1
Student ID SATScores GMAT Scores
Tom 500
Berry 300
Matt 100

File 2
Student ID SATScores GMAT Scores
Tom 200
Berry 300
Matt 100 700

There are about 5000 rows like this in both the files. I want to combine
these two files so that what I will get is following:

Merged File
Student ID SATScores GMAT Scores
Tom 500 200
Berry 300
Matt 100 700

Hope this explains my problem more clearly.

Joe Green



: