compare 2 columns and highlight words that don't match then split difference

  • Hi,


    I have a large amount of data in each cell in column A and B . I want to compare and highlight words that don't match. For that I try the below macro. I want to split that red fonts string to next cell. But I have trouble in splitting red font words because it takes more time for splitting. Anyone have better macro for compare and split the difference? I have attached macro workbook which I tried.


    I want macro to display output like this,


    [TABLE="width: 500"]

    [tr]


    [td]

    A

    [/td]


    [td]

    B

    [/td]


    [td]

    C

    [/td]


    [/tr]


    [tr]


    [td]

    AAAB

    [/td]


    [td]

    AAA

    [/td]


    [td]

    B

    [/td]


    [/tr]


    [/TABLE]



    thanks & Regards,
    Deva

  • Re: compare 2 columns and highlight words that don't match then split difference


    Finally I found this code!


    But its getting late can any one say solution?

Participate now!

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