macro to compare 2 sheets row wise and copy unmatched data to 3rd sheet

I looking for a fast macro dat will compare two excel sheets(containing large amount of data) row wise..here i want to take one row from first excel sheet and compare with all rows in another excel sheet.if any of the row from first sheet completely matches with any of the rows in second excel sheet then its ok ,but if doesnt match then copy dat row to 3rd sheet...

for example
Sheet 1

column1 column2
aa bb
dd dd

Sheet 2

column1 column2
e e
aa bb

Sheet 3

column1 column2
dd dd


I tried wid the following code:

Please Login or Register  to view this content.

its working as required but got stucked for long data.

Then got an idea to use varient for faster comparison.

Now clueless how to go ahead...can anyone help me in this ?

Moderator's Edit: Use code tags when posting code. To do so, select your code and click on the # icon above. I have done it for you this time.

Is there any unique column which can be used to compare both sheets?

So each column needs to be checked with each column in a row in the other sheet? How many columns are there?

Even if there is a mismatch in one column, it should be copied to the next sheet?

Yes, but to compare each row, we have to move from one column to the other, right?

For e.g. compare sheet1 A2 with Sheet2 A2, then move to Sheet1 A3 and compare with Sheet2 A3, etc.

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.