Hi all,
I need a macro to compare two sheets and find differences. You may
find an example herebelow.
Sheet 1
BSIU2149460 20' BO EMP EVERGREEN
BSIU2150666 20' BO EMP EVERGREEN
CRXU3075629 20' BO FCL HML
EISU1446173 40' BO FCL HML
EISU1471129 40' BO FCL HML
EISU3538242 20' BO FCL HML
EISU3574933 20' BO EMP EVERGREEN
EISU3610820 20' BO EMP EVERGREEN
EISU1234567 20' BO EMP EVERGREEN
Sheet 2
BSIU2149460 20' BO EMP EVERGREEN
BSIU2150666 20' BO EMP EVERGREEN
CRXU3075629 20' BO FCL HML
CRXU3075629 20' BO FCL HML
EISU1446173 40' BO FCL HML
EISU1471129 40' BO FCL HML
EISU3574933 20' BO EMP EVERGREEN
EISU3610820 20' BO EMP EVERGREEN
EISU3626425 20' BO FCL HML
*Firstly macro have to find differences between Sheet1 Column A and Sheet 2 Column A. If find
a different entry in Sheet 1(for exmp EISU1234567) it will move this line to Sheet 3(with other cells in the same line).
*After that,it will check dual entries to Sheet 2(for exmp CRXU3075629) and move them to Sheet 4(I have to know if there is a double entry).
*After these steps, line numbers of Sheet1 and Sheet2 will be equal and
they will include same data according to Column A.
*At last, macro will compare B, C, and D columns and if there are differences , it
will mark these cells with different colour on Sheet 2.
Thanks in advance...
I need a macro to compare two sheets and find differences. You may
find an example herebelow.
Sheet 1
BSIU2149460 20' BO EMP EVERGREEN
BSIU2150666 20' BO EMP EVERGREEN
CRXU3075629 20' BO FCL HML
EISU1446173 40' BO FCL HML
EISU1471129 40' BO FCL HML
EISU3538242 20' BO FCL HML
EISU3574933 20' BO EMP EVERGREEN
EISU3610820 20' BO EMP EVERGREEN
EISU1234567 20' BO EMP EVERGREEN
Sheet 2
BSIU2149460 20' BO EMP EVERGREEN
BSIU2150666 20' BO EMP EVERGREEN
CRXU3075629 20' BO FCL HML
CRXU3075629 20' BO FCL HML
EISU1446173 40' BO FCL HML
EISU1471129 40' BO FCL HML
EISU3574933 20' BO EMP EVERGREEN
EISU3610820 20' BO EMP EVERGREEN
EISU3626425 20' BO FCL HML
*Firstly macro have to find differences between Sheet1 Column A and Sheet 2 Column A. If find
a different entry in Sheet 1(for exmp EISU1234567) it will move this line to Sheet 3(with other cells in the same line).
*After that,it will check dual entries to Sheet 2(for exmp CRXU3075629) and move them to Sheet 4(I have to know if there is a double entry).
*After these steps, line numbers of Sheet1 and Sheet2 will be equal and
they will include same data according to Column A.
*At last, macro will compare B, C, and D columns and if there are differences , it
will mark these cells with different colour on Sheet 2.
Thanks in advance...