Compare 2 sheets

Hey guys.

I have been trolling the forums for hours, but Im beyond my depth here.

I would really appreciate a quick and easy formula to help me out.

I have 2 sheets. 4 columns each. A, B, C, D

I need to compare column C on both sheets and give me the full 4 columns results of missing data from sheet 2 on sheet 3

I hope someone can help.

thanks

You have not said what type of data is column C string,number or date.anyhow try this macro and see whether you get what you want. no duplicates in col c wither in sheet 1 or sheet 2. no empty row in between.

Sub test()
Dim x, r1 As Range, r2 As Range, c2 As Range
Dim cfind As Range
Worksheets("sheet3").Cells.Clear
With Worksheets("sheet2")
Set r2 = Range(.Range("C2"), .Range("C2").End(xlDown))
For Each c2 In r2
x = c2.Value
With Worksheets("sheet1").Columns("C:C")
Set cfind = .Cells.Find(what:=x, lookat:=xlWhole)
If cfind Is Nothing Then
c2.EntireRow.Copy
Else
GoTo nextc2
End If
With Worksheets("sheet3")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
End With
nextc2:
Next c2
End With

End Sub

thankyou venkat for the reply.

sorry for the lack of information, but im a real newbie when it comes to this. Im just trying to help the girlfriend.
she needs to compare ID numbers with sheet 1 and sheet 2 both column D and get the missing data to a new sheet (all rows of missing data) sheet 1 will have the correct data, where sheet 2 is where we think there are missing ID's and perhaps some new ID's that are not in sheet 1. (new clients)

confusing I know.

screenshot below.

thanks again for your help and time.

\1

Hi,
it would be much more useful to attach a sample sheet than a picture. ( or someone might give you a picture as answer...)