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

O

omar6881

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose & reorg data from 2 WS to new WB 2
Match 2 set data and combine to 1set 2
fastest way to check if a table contains the data 2
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Sort data 1
Match and Extract Data 1
Compare 2 data set 2
Compare Names in a column and create single list with adjacent vla 3

Top