View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wira Wira is offline
external usenet poster
 
Posts: 6
Default 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