I need a macro to compare sheets and make some arrangements

barissh

Board Regular
Joined
Aug 10, 2006
Messages
94
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...
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,136,616
Messages
5,676,835
Members
419,653
Latest member
analyticalchemist94

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top