Sub QTY()
ARR = Sheets("QTY from MP 2012 AOP").Range("A3:r" & Sheets("QTY from MP 2012 AOP").Range("A65536").End(3).Row)
BRR = Sheets("2013 APAC Project List ").Range("A8:AH" & Sheets("QTY from MP 2012 AOP").Range("A65536").End(3).Row)
For I = 1 To UBound(ARR)
For J = 1 To UBound(BRR)
If BRR(J, 1) = ARR(I, 1) Then
For K = 23 To 34
BRR(J, K) = ARR(I, K - 16)
Next
End If
Next
Next
Sheets("2013 APAC Project List ").Range("A8").Resize(UBound(BRR), 34) = BRR
End Sub