How to match data between 2 different sheets

[Saed]

Dear All,

Kindly I have data in sheet 1 & data in sheet 2, I need the data which is
not matching to be transfer to sheet 3.

 

[Cimjet]

Hi Saed
Is this what your looking for?
=IF(Sheet1!A1<>Sheet2!A1,Sheet1!A1)
Regards
Cimjet

 

[Hassan]

Hi Cimjet,

Thanks for your respond, actually I think I didnt explain wel that is the
reason, your reply didnt help me.

I have a large data in excel file Sheet 1, and some updation on Sheet 2 on
the same excel file. Now I want to check which are missing data in sheet 2,
so I am looking some formula or macro to copy missing data in Sheet 3, then I
can easily update the data accordingly.

Thanks & Regards

Saed

 

[Cimjet]

HI Saed
I don't know if i can help you, I sent you a link with a sample file named
"CheckA&B2C" this is what I understand from your comments.
Post back with more explanation and maybe if not myself, someone else can
help you.
http://www.savefile.com/projects/808612528
Good Luck
Cimjet