Comparison and identifying & listing unique values in the Columns

[sppanchal197]

Hello all,
I am working on an automation task, where i am requried to compare & identify the unique part numbers from Base-BOM & other BOMS. my needs are as follows:
1) The mismatching values should get highlighted and the values of those cells should be copied to another cells

I have worked on it, but I am only able to identify the cells where the values are not matching. Can someone help me to figure this out.

I have placed a the screen grab at : BOM Pictures, BOM Images, BOM Photos, BOM Videos - Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

Formula in Cell K6 is =IF(ISERROR(MATCH(B6,$C$6:$C$810,0)),"",B6)

Can i get the values in place of RED FILLED CELLS

regards,
Sundeep