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"]
A
B
C
AAAB
AAA
B
[/TABLE]
thanks & Regards,
Deva