Compare and highlight cell next to duplicates of two sheets

[Justalittlelost]

Hello,

I am seeking a macro to compare columns (column 9, starting at row 6) between two sheets, Sheet1 and Sheet2 and then dumping the entire row with the duplicates in sheet 3.

For example:

Sheet1 has on row 6 and column f,g,h:
1 // a // X
Sheet2 has the same items on row 15

So sheet 3 will display the entire row 6 (ie columns a - s ) of sheet one.

Could anybody help me with this?

I could also provide a dummy excel file if needed.

Thanks

 

[PCL]

Is the order of the values is important ?
e.g. 1 // a // X duplicate of a // 1 // X

 

[Justalittlelost]

Hi PCL,

No, the order is not important.
In fact, i actually phrased it incorrectly

The macro needs to compare column g in sheet 2 with sheet 1, the cell consists of a bunch of numbers.

If the numbers in column g on sheet 2 do not appear on sheet 1 column g, then the whole row on sheet 2 needs to be copied to sheet 3.

I hope this makes sense and thank you in advance!