View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xxer Xxes Xxer Xxes is offline
external usenet poster
 
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Hi, and a good evening

I need to compare two columns ; I need something
like this :

1.for each my cell in myRng1( myRng1 is BT1:BT200 )
2.compare with each my cell from myRng2 ( myRng2 is
BD11:BD42000 )
3.IF it is a match , Then , copy ,, Range.my cell from myRng2.Offset(0, 7) untill,,(:)"
my cell from myRng2.Offset(0, 9) ,,
4. Destination (of the copy) : my cell from myRng1.Offset(0, 3)

Thank you so much for any suggestions and assistence.