VBA - Comparison two sheets and entire row - HARD ONE

[NeewBie]

Hi

I have a problem that is hard to solve. Im looking for an VBA script (not funcion) that:
1. Compare entire rows (Column A-K) in Sheet1 with Sheet2 (Columna A-K). NOTE! Important that its entire row.
2. If it finds an dublicate somewhere show it in Sheet3
3. The big problem is that the rows is not sorted and both sheets dont have equally rows.

Its this possible?

 

[hiker95]

NeewBie,

Its this possible?

Probably.

What version of Excel are you using?

Can we have screenshots (columns A thru K) of Sheet1 and Sheet2, and a screenshot of what the results should look like in Sheet3?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker


If you are not able to give us screenshots:
You can upload your workbook containing worksheets Sheet1 Sheet2 and Sheet3 (manually formatted by you for the results you are looking for) to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.