check the records, report the different ones

ageren

Board Regular
Joined
Jul 30, 2007
Messages
60
hi everyone,

please find attached the excel workbook includes two data series (b2:g36 is the one and I2:n36 is the other aggregation) which should be exactly the same.

Here are my questions with its examples :

1) In case of matching the data in the line of I2:N2 with the any and every data in the range of b2:g36, our macro code we will create should be clear the each data both I2:N2 and the matching data of I2:N2 in the range of b2:g36.


example 1)

data in the line of I2:N2 are as follow;

136 rrr TCELL 302 21.05.2007 2412.38

one and only section matches with that data in the range of b2:g36 is the line of b2:g2;

136 rrr TCELL 302 21.05.2007 2412.38

in accordance with the information above, our macro should clear both I2:N2 and b2:g2 lines..

2) in case of having different values of client, equity code or qty or date of acquisition or cost, on condition that the acc number will be the same, macro code should paint to yellow each different cell

example 2)

data in the line of I31 : N31 are as follow;

735180 so IDAS 200,000.000 15.12.2006 92,477.620

however, 735180 acc number' s data in the line of b26:g26 looks like

735180 so IDAS 20000 15.12.2006 92400

in accordance with that information, macro code should paint both E26 (qty cell) and L31 (qty cell) to yellow at the same time. Additionaly, no data should be cleared by the macro in these lines as well.

ımportant condition :

in case of matching the costs, ten percent differences among the two series should not be decerned as real differance by the macro code..

thanks for your help..
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,181,658
Messages
5,931,270
Members
436,785
Latest member
KingGideon

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