How to match data between 2 different sheets
 

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.

How to match data between 2 different sheets
 

Hi Saed
Is this what your looking for?
=IF(Sheet1!A1<Sheet2!A1,Sheet1!A1)
Regards
Cimjet
"Saed" wrote in message
...
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.

How to match data between 2 different sheets
 

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" wrote:

Hi Saed
Is this what your looking for?
=IF(Sheet1!A1<Sheet2!A1,Sheet1!A1)
Regards
Cimjet
"Saed" wrote in message
...
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.

How to match data between 2 different sheets
 

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


"Hassan" wrote in message
...
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" wrote:

Hi Saed
Is this what your looking for?
=IF(Sheet1!A1<Sheet2!A1,Sheet1!A1)
Regards
Cimjet
"Saed" wrote in message
...
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.