Using macro to do cell matching

[wira]

Hi guys,

I need to do some cell matching between 2 lists. Let say i have a source and
target list at column A and B from seperate w/sheet. Starting from the top,
the program will detect cell one by one and try to match it with the target
list from the other w/sheet. That one is not a problem for me, the only
problem is there are some of the cells from source list that are not in the
target list and vice versa. How to pin point the cells and copy it to another
w/sheet.


Appreciate ur help,

wira

[Norman Jones]

Hi Wira,

See Chip Pearson's formula approach at:

http://www.cpearson.com/excel/duplic...tingDuplicates

For your immediate purposes, look particularly at the last two sections on
this page.

---
Regards,
Norman



"wira" <[email protected]> wrote in message
news:[email protected]...
> Hi guys,
>
> I need to do some cell matching between 2 lists. Let say i have a source
> and
> target list at column A and B from seperate w/sheet. Starting from the
> top,
> the program will detect cell one by one and try to match it with the
> target
> list from the other w/sheet. That one is not a problem for me, the only
> problem is there are some of the cells from source list that are not in
> the
> target list and vice versa. How to pin point the cells and copy it to
> another
> w/sheet.
>
>
> Appreciate ur help,
>
> wira