hi ..
I have "stoke" sheet with a code names in column B ..
and I have another sheet "sat" .. whith code names in column B starting from B2
I want a code to check if all codes in "sat" sheet exists in "stoke" sheet and if that code not exists I want to add it to the bottom of "stoke" sheet
I found this code in the forum from AB33 .. but when I tried it and checked the result ,, I found that some codes not copied ..
I don't know why ??
Dim c3 As Range
Dim c4 As Range
Dim LR2 As String
With Sheets("sat")
LR2 = .Cells.Find(what:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
For Each c4 In .Range("B2:B" & LR2)
Set c3 = Sheets("Stoke").Columns(2).Find(c4, , xlValues, xlWhole)
If c3 Is Nothing Then
c4.EntireRow.Copy Sheets("Stoke").Cells(Rows.Count, 1).End(xlUp).Offset(1)
End If
Next
End With
hope that I can find the answer
Bookmarks