Hi,

I have two workbooks with different types of data about the same groups of
people.

There is one column containing an ID number which is common to both files.

I wanted to copy matching data from one worksheet to the other and thought I
would just sort both workbooks on ID number and copy ID number column and the
other data column. Sounded simple until I realised that the ID number is
repeated for different numbers of rows from 14 to 31 containing different
data about the person. Currently I'm cutting and pasting data matching
manually but there are over 15000 rows.

So if anyone can suggest a method of doing this I would be so HAPPY!

Thank you in advance
cheers


--
Mifty