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.

Please Login or Register  to view this content.

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...)