Solved: Comparing 2 Sheets in a Workbook minor bug

[itipu]

Ladies & Gents,

Some minor bug in my script except can't quite figure out what it is...

I am tring to compare Column A in sheet1 with column A in sheet2 and whatever is not found in sheet2's Column A should be outputted to sheet3 column A at the moment it starts ok, but does not do next for some reason

Your help as always is much appreciated!!!!!!

Thanks a lot

[mdmackillop]

Hi Itipu,
Minor bug as you said. You're writing all your data to the same cell A1.

Try
[vba]If rngFind Is Nothing Then
rngCell.EntireRow.Copy sh.Cells(Rows.Count, 1).End(xlUp).Offset(1)
End If
[/vba]

[itipu]

Thanks