Hi all,
I want to compare two cells in excel using macro and populate the difference after executing the macro.
If any body has worked on this requesting your help in this regard.
<tbody>
</tbody>
I want to compare two cells in excel using macro and populate the difference after executing the macro.
If any body has worked on this requesting your help in this regard.
this is the my house | this is huge the house |
tests are normal | tests normal |
there is a small pot | this is pot |
this is sum | this is huge sum |
Just be to change addresses in the below to match your worksheet. | Just be sure to the change addresses in the lines to match worksheet. |
Since added requirements in the comments below, I modified the code to also print out the list of red-highlighted phrases in column C. If you want this list elsewhere, you'll have adjust the address in the last section of the code. I also improved code | Since you added requirements in the comments below, I modified the code to also print out the list of red-highlighted phrases in column C. If you want this list elsewhere, you'll have to adjust the address in the last section of the code. I also improved the highlighting code |
<tbody>
</tbody>