Hi,
I have two lists. Each list contains two columns. Both columns in a row
represent an identification that is unique. For example, collumn A = 114555
and the B = 104. Those two columns are in columns A and B and the other list
exactly the same one but in a completly different order is in columns AG and
AH. So the code must search for each identification from combination AG and
AH to find where is the same combination in columns A and B and then copy
columns AG to BL from the row from combination AG and AH to this new location
(columns A to AF) that was found with the 2 cells value from columns A and B.

Note that the list is dynamic. So I use the code line in the code tag below
to determine the number of rows (the two lists are in the same range of rows
and have the same number of rows.) Also, the main reason why I do that is
because I have a complexe sorting function that works well but that does not
copy the values attached to their identification when those identifications
moves (see also the link below to see that special sorting function if you
want).

Link :
http://www.ozgrid.com/forum/showthread.php?t=22170

Could anybody help me on that one?

Thx!

Werner


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1