Hi,

I would like to merge 2 excel workbooks that have around 5000 rows. 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
Jake 500

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
Jake 500

Any clues how to do this?

Joe