Loop Through Range 2 ranges

[realniceguy5000]

Hi, I need some help. I have 2 worksheets I need to check. i need to loop through sheet1 column a, find same value on sheet2 column a then somehow loop through each column on sheet1 same row and check the row that was found on sheet2 each column to make sure they match if they dont match then I need to mark the cells on both sheets and continue checking the values accross the entire row. Once done checking if they dont match move the rows to sheet3

Here is what I came up with so far but I am stuck.


Thanks for any help

Sub ColumnChecks()
colcount = 1
    With Sheets(1)
        Lrow1 = .Cells(Rows.Count, 1).End(xlUp).Row
        Lcol1 = .Cells(1, 256).End(xlToLeft).Column
            For x = Lrow1 To 2 Step -1
                For y = 1 To Lcol1
                    '.Cells(x, y).Select
                    Set c = .Cells(x, y)
                        With Sheets(2)
                            .Select
                               Set cfind = .Columns(1).Cells.Find(what:=c.Value, lookat:=xlWhole)
                               
 'not sure what now as I found the row on the 2 sheet but have to loop through values on the first sheet and loop
                                ' through this row on the 2nd sheet
                                
                                                  
                        
                        
                        
                        End With
                Next y
            Next x
    
    
    End With
    
End Sub

 

[realniceguy5000]

Oh I just thought of something. sometimes I have more Data in one of the worksheets so the rows dont always match up. I think that is what I meant when I said I need to find the matching row on sheet2 before I start the loop. Can you think of anyway around that?

Thank You Again...

 

[kevatarvind]

can you upload your file any sharing site and paste that link here ?

 

[realniceguy5000]

Compare 2 worksheets by rows then columns

I posted this on another site when I was looking for all the answers. The workbook should explain what I want. Post back any questions you may have, thank you

 

[kevatarvind]

sorry but from that site i am unable to download any file or not able reply and post there or cant post new thread i dont know why

you mail me that file i am giving my mail in pm check your pm

 

[realniceguy5000]

I sent the file to your email you sent me, Thank You for your support