Using macro to do cell matching
 

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

Using macro to do cell matching
 

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