Compare data set 1 with data set 2. Add to data set 2 if not found

Joined
Jul 21, 2012
Messages
1
Reaction score
0
Any help with following is much appreciated

I have 2 data sets (DS1 and DS2) in the same workbook (sheets 1 and sheets 2 respectively)

I would like to compare pairs of values from User Name (col. A) and Course (col. B) in DS1 to User Name (col. A) and Course (col. B) in DS2.

If the combination does not exist then the values need to be appended to last row of User Name and Course columns in DS2

NB. DS2 may have manual user input in (Col. C) such as dates so any solution cannot cause a mismatch of row data therefore has to be inserted within records or appended to the last row

data example:

DS1
Name---Course
Jack----Health
Jack----Finance
Joe-----Fiance


DS2
Name----Course----User input
Jack-----Health
Joe------Fiance----15/05/2012


So in this example it would be below that is added to DS2
Jack-----Finance


Thanks in advance for any help provided
 
Back
Top