How to match data between 2 different sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saed - 03 Mar 2008 11:38 GMT

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.

Reply to this Message

Cimjet - 03 Mar 2008 14:28 GMT

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

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

Reply to this Message

Hassan - 04 Mar 2008 05:15 GMT

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

> Hi Saed
> Is this what your looking for?
[quoted text clipped - 6 lines]
> > is
> > not matching to be transfer to sheet 3.

Reply to this Message

Cimjet - 04 Mar 2008 14:55 GMT

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

> Hi Cimjet,
>
[quoted text clipped - 23 lines]
>> > is
>> > not matching to be transfer to sheet 3.

Reply to this Message