Searching the row that contains the same two columns
 

Hi,

I have two lists. Each list contains two columns. Both columns in a ro
represent an identification that is unique. For example, collumn A
114555 and the B = 104. Those two columns are in columns A and B an
the other list exactly the same one but in a completly different orde
is in columns AG and AH. So the code must search for eac
identification from combination AG and AH to find where is the sam
combination in columns A and B and then copy columns AG to BL from th
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 ta
below to determine the number of rows (the two lists are in the sam
range of rows and have the same number of rows.) Also, the main reaso
why I do that is because I have a complexe sorting function that work
well but that does not copy the values attached to their identificatio
when those identifications moves (see also the link below to see tha
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


Code
-------------------


Let lstRw = Sheets("Formulaire").Range("a65536").End(xlUp).Row


-------------------

--
Werne
-----------------------------------------------------------------------
Werner's Profile: http://www.excelforum.com/member.php...fo&userid=2430
View this thread: http://www.excelforum.com/showthread.php?threadid=38572