merce excel rows based on an ID column?

[ericb123]

Any help is appreciated. I have 2 spread sheets, one is employee productivity, one is employee quality. They both have a userID field.

I would like to combine these into 1 sheet so that I can create pivot tables, etc. Is there a way or a function to take sheet1 and sheet2 and merge them into 1 new sheet where it matches up the rows based on a unique ID?

Any help is greatly appreciated, thanks!

 

[SkipVought]

Hi,

Check out faq68-5829.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]