Hi,
i need to compare two columns for differences and highlight them; the columns may contain duplicate data.
As example, for the below two columns, DWB931 on column A and DWD966 from column B should be highlighted. Note that there is one DWD966 in column A but two in column B.
i need to do this in VBA.
Thanks
<colgroup><col span="2"></colgroup><tbody>
</tbody>
i need to compare two columns for differences and highlight them; the columns may contain duplicate data.
As example, for the below two columns, DWB931 on column A and DWD966 from column B should be highlighted. Note that there is one DWD966 in column A but two in column B.
i need to do this in VBA.
Thanks
DWB010 | DWB010 |
DWB251 | DWB251 |
DWB253 | DWB253 |
DWB931 | DWD860 |
DWD860 | DWD860 |
DWD860 | DWD861 |
DWD861 | DWD862 |
DWD862 | DWD911 |
DWD911 | DWD912 |
DWD912 | DWD913 |
DWD913 | DWD914 |
DWD914 | DWD915 |
DWD915 | DWD920 |
DWD920 | DWD922 |
DWD922 | DWD966 |
DWD966 | DWD966 |
DWD967 | DWD967 |
DWD968 | DWD968 |
EBO101 | EBO101 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>