Range("B7:F200").ClearContents
For x = 2 To 6
n1 = 0
For I = 4 To 200
If Sheet2.Cells(I, 2) = Cells(6, x) Then
n1 = n1 + 1
Cells(n1 + 6, x) = Sheet2.Cells(I, 3)
End If
Next
Next x
Range("B7:F200").ClearContents
For x = 2 To 6
n1 = 0
For I = 4 To 200
If Sheet2.Cells(I, 2) = Cells(6, x) Then
n1 = n1 + 1
Cells(n1 + 6, x) = Sheet2.Cells(I, 3)
End If
Next
Next x