How to compare data between 2 worksheets and display the differences

**melvyndb** · 05-01-2012, 11:28 PM

I need the help of experts.

I have attached the sample and hope to receive help urgently. 30042012.zip

basically, I need to find the ID that is not in D1, but is present in D. so i.e.(ID 12345 in D but not present in D1), then display that ID number.

I am thinking of using MATCH and INDEX, but anything would do as long as it works. Hope that clarifies my needs, thank you and need help badly.

regards,
Melvyn

**jraj1106** · 05-02-2012, 02:01 AM

Hi

Id in D is not in D1 then where should that row be displayed?

**jraj1106** · 05-02-2012, 02:38 AM

Hi

Try this. Hope this will help you...

30042012.xls

This is the code:

Sub findmatch()
Dim rd As Long, rd1 As Long, finalcnt As Long

rd = Sheets("D").Range("A" & Rows.Count).End(xlUp).Row
rd1 = Sheets("D1").Range("A" & Rows.Count).End(xlUp).Row
finalcnt = Sheets("Difference").Range("A" & Rows.Count).End(xlUp).Row

For i = 2 To rd
For j = i To rd1
If Sheets("D").Range("A" & i).Value <> Sheets("D1").Range("A" & j).Value Then
finalcnt = finalcnt + 1
Sheets("Difference").Range("A" & finalcnt).Value = Sheets("D").Range("A" & i).Value
Else
Exit For
End If
Next
If j > rd1 Then
finalcnt = finalcnt + 1
Sheets("Difference").Range("A" & finalcnt).Value = Sheets("D").Range("A" & i).Value
End If
Next
End Sub

**arlu1201** · 05-02-2012, 02:48 AM

Raj,

Please use code tags.

**arlu1201** · 05-02-2012, 02:48 AM

Also,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.