+ Reply to Thread
Results 1 to 2 of 2

Using macro to do cell matching

  1. #1
    wira
    Guest

    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. #2
    Norman Jones
    Guest

    Re: 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" <[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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1