Problem with search and replace data,thanks for you help in advance.

There is a file in attachment with many data in 'Raw Data' and 'Mid II' tables,I wanna

to:

comparing K column in each row with the same column in its next row,if they are the

same,we'll pass,if there are something different,we would:
1. copy the value in column D to Column B in the current row;
2. copy the value in column K of the next row to column A,and add ' Open' at the end of

the value;
3. in the raw data, seek the row with the same data as the value in column C,column K

in current row,and copy the value from column D to column J of that row to the

corresponding columns and raw in table Mid II.

for example:

We start from the ending to the beginning.In both the raw 2239 and 2340,table Mid

II,the values in column K are all '9',so we pass them and do nothing.
Now we are in raw 2238,we compare the values in column K in both raw 2238 and 2239 in table Mid II,they are '8' and '9',it's different,so we:

1. copy the value '56000' in column D to column B in the same raw;
2. copy value '9' in column K,raw 2239 to the column A,current raw(raw 2238),and add a ' open' in the destination;
3. seek the value from column C and K in current raw('2006-6-15',and '8' respectively) in table 'raw data',we find that the values in column A and H,raw 21134 are the same,so we copy the values from column B to G in raw 21134,table 'raw data' and repalce the value in column D to J,raw 2238.(But in the attachment,in order to demonstrate the steps above,I didn't really repalce the value,although it should be replaced,actually).

It took me almost a whole day to do these,but I can't overcome it,please help,thanks in advance.

best regards.

Is this problem really hard??