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
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