Merging data from two excel spreadsheets 1

[cdulong]

Hello,

I am looking for a script or method to merge data from two Excel spreadsheets. The data is set up as follows:


Sheet 1
Name Age
Bill 11
Charles 14
Aaron 16

Sheet 2
Name Weight
Bill 200
Jim 240
Charles 220
Aaron 190
James 185

Expected results:

Sheet 3
Name Age Weight
Bill 11 200
Charles 14 220
Aaron 16 190

* If the name appears in the first sheet it needs to appear in the third sheet with the coresponding value from the second sheet.

Any help would be greatly appricated.

Thanks,
cdulong

 

[SkipVought]

Use MS Query. No vba necessary.

faq68-5829.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cdulong]

Thanks!!!

That is exactly what I was looking for.

cdulong