check the records, report the different ones

[ageren]

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..