Hi there,
I would like to compare rows (with multiple criteria/columns) between two different sheets and if a match is found the row is copied to a new sheet. So for example Sheet1 contains a 10 rows with information in column A to D and Sheet2 also contains 10 rows with information A to D. I would like to copy the rows which contain the same information in column A to D and extract it in a new Sheet3. I've attached a small example file. Hope somebody can help me out with this! Thank you.
Maybe:
Please Login or Register to view this content.
Works perfect! Thank you! However, I have one more question. Is it also possible to compare two sheets on values in column A and D and when there is a match found the entire row (including values from column B and C) is copied/extracted in the new Sheet3?
Modified from Davis' CODE
Sub Compare_2Rows_AD()
Dim i As Long, y As Range
With Sheets("Sheet1")
For i = 2 To .Range("A" & Rows.Count).End(3).Row
For Each y In Sheets("Sheet2").Range("A2:A" & Sheets("Sheet2").Range("A" & Rows.Count).End(3).Row)
If y.Value = .Cells(i, "A").Value And y.Offset(, 3).Value = .Cells(i, "D").Value Then
.Rows(i).Copy Sheets("Sheet3").Range("A" & Rows.Count).End(3)(2)
Exit For
End If
Next y
Next i
End With
End Sub
Last edited by tuongtu3; 07-04-2016 at 03:23 AM.
Thank you for the modifying tuongtu3. I was trying to modify it to my specific needs but I couldn't find the right way.. I hope you (or someone ells) could modify it for me?
In my file I have column A to P containing information (with over 2000 rows). I want to compare column D, F, G, H, I, J, K, L, M, N, O, P in sheet1 with corresponding columns in sheet2. When there is a match found in all of these columns I would like the entire column (including the information in column A, B, C and E) to be copied to sheet3.
Hope somebody could help me out since I couldn't find the right way to modify the macro that is posted above. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks