This code to copy the values from sheet2 to sheet3 only the new values. it's mean if there is a match vlaue in sheet3 it will not print it
[vba]
Dim myRange3 As Range
Dim R As Long
Dim cell As Range
Set myRange3 = Worksheets(2).Range("A1:A100")
For Each cell In myRange3
If IsError(Application.Match(cell.Value, Sheets(3).Columns(1), 0)) Then
R = Sheets(3).UsedRange.Rows.Count
If R <> 1 Or Sheets(3).Range("A1").Value <> "" Then R = R + 1
cell.Copy Sheets(3).Range("a" & R)
End If
Next cell
[/vba]
I want to deal this code to copy four value togather in the same row, but if the four values in sheet2are match to four values in sheet3 itwill not copy them .it 's mean if there are in sheet2 George,25,Germany,big and there are smae vlaues in sheet3 George,25,Germany,big .it will not copy only if there is difference in one vlaue at least .it's mean if Gorge,25,itlay,big it's difference in italy than Germany.I hope I'm clear. and thank you for help.