For Each C_1 In Data_1
For Each C_2 In Data_2
If C_2 = C_1 Then
'found a cell on sheet2 that matched cell in sheet1
'now do what you need to do
Data_2.EntireRow.Copy Destination:=Worksheets("New_Master").range("A5000").End(xlUp).Offset(1, 0)
When I run this it just copies everything to the sheet called New_Master, including the non-matches.
What am I missing? It has to be obvious, that's usually the case. ;-)