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

+-------------------------------------------------------------------+
|Filename: Conjuction 2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4907 |
+-------------------------------------------------------------------+

--
yoyo2000
------------------------------------------------------------------------
yoyo2000's Profile: http://www.excelforum.com/member.php...o&userid=15489
View this thread: http://www.excelforum.com/showthread...hreadid=553359