Compare two worksheet and copy the diffrences on a new row in sheet 1

[patli]

Hi all,

Thank you for a fantastic forum!

I have some problems comparing two worksheets (Sheet 1 and Sheet 2). I would like to compare colum A in Sheet 1 (starting at A2) with colum K in sheet 2 (starting at K2). Before the comparing starts, I need to filter sheet 2 from duplicates depending on colum K. If there is a difference between sheet 1 and sheet 2, I would like to copy colum K and colum N from spreed 2 to the first blank row in spreed 1 colum A resp. colum B

My problem is that I am updating the whole sheet 1 but I would like that sheet 1 only is updated with the diffrences between sheet 1 and sheet 2.



Please see enclosed file for example.