Filter and compare each cell based on base cell and return the Difference in newsheet

  • Hi All,


    I have Base record and Based on that I have n number of record with different name. Every record have common format but they create with some error how to identify that in vb:). How to compare that?


    Sheet1:BASE
    [TABLE="class: grid, width: 500"]

    [tr]


    [td]

    NAME

    [/td]


    [td]

    ID

    [/td]


    [td]

    VALUES

    [/td]


    [/tr]


    [tr]


    [td]

    ICV1

    [/td]


    [td]

    APPLE

    [/td]


    [td]

    250 FROM GARDEN

    [/td]


    [/tr]


    [tr]


    [td]

    ICV1

    [/td]


    [td]

    BANANA

    [/td]


    [td]

    NOT AVAILABLE

    [/td]


    [/tr]


    [tr]


    [td]

    ICV1

    [/td]


    [td]

    ORANGE

    [/td]


    [td]

    $25 HAVE IN STOCK

    [/td]


    [/tr]


    [/TABLE]

    Sheet2:RECORDS
    [TABLE="class: grid, width: 500"]

    [tr]


    [td]

    NAME

    [/td]


    [td]

    ID

    [/td]


    [td]

    VALUES

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    APPLE

    [/td]


    [td]

    250 FROM GAR

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    BANANA

    [/td]


    [td]

    AVAILABLE

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    ORANGE

    [/td]


    [td]

    $25 NOT IN STOCK

    [/td]


    [/tr]


    [tr]


    [td]

    IBB2

    [/td]


    [td]

    APPLE

    [/td]


    [td]

    250 FROM GARDEN

    [/td]


    [/tr]


    [tr]


    [td]

    IBB2

    [/td]


    [td]

    BANANA

    [/td]


    [td]

    NOT AVAILABLE

    [/td]


    [/tr]


    [tr]


    [td]

    IBB2

    [/td]


    [td]

    ORANGE

    [/td]


    [td]

    $25 HAVE IN STOCK

    [/td]


    [/tr]


    [/TABLE]



    I want result like,


    SHEET3:RESULT


    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [td]

    NAME

    [/td]


    [td]

    ID

    [/td]


    [td]

    DIFFERENCE

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    APPLE

    [/td]


    [td]

    DEN

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    BANANA

    [/td]


    [td]

    NOT

    [/td]


    [/tr]


    [tr]


    [td]

    IBB1

    [/td]


    [td]

    ORANGE

    [/td]


    [td]

    NOT

    [/td]


    [/tr]


    [/TABLE]







    Can Macro will display only differences in the each name??:roll:
    Regards,
    Deva

  • Re: Filter and compare each cell based on base cell and return the Difference in news


    As you seem to be ignoring private messages - Please stop posting edited versions of the same issue.


    If you need to add information to a post, then use the 'Edit Post' link below the message. This is available to you for some hours after posting.


    Your other posts for a similar issue have been closed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!