Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO for Matching Two List | Excel Worksheet Functions | |||
macro copy data wb1 matching date to wb2 | Excel Discussion (Misc queries) | |||
$%Macro to Copy from one workbook to other when matching data | Excel Discussion (Misc queries) | |||
macro paste by matching dates | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |