Compare,copy and paste if true
 

I have 10 names(actually many more,just for example) in column A. I have
100 numbers in columns B and 100 numbers in column C that correspond
sequentially to the names in column A . I need a macro that will
compare the value in cell B1 to the value in B2 and value of C1 to the
value of C2. If both match then I need the name in cell A1 to be copied
to A2 with the rest of the names in column A shifted down to make room
for the duplicate name. Then I need the whole process to repeat at cell
B2 etc till the end of the list. At the end of the macro,I should have
100 names in column A.



Thanks


--
light
------------------------------------------------------------------------
light's Profile: http://www.excelforum.com/member.php...fo&userid=7228
View this thread: http://www.excelforum.com/showthread...hreadid=393563