1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Option Explicit
Dim t, z As Variant, t2() As String, c As Range, x As Long, i As Long, k As Long
Sub tri()
On Error Resume Next
Application.ScreenUpdating = False
With Sheets(2)
For Each c In .Range("a2", .Range("a65536").End(xlUp))
z = c.Offset(0, 2)
With Sheets(1)
t = .Range("a4:k" & .Range("a65536").End(xlUp).Row)
x = 1
For i = 1 To UBound(t)
If t(i, 2) = c.Value Then
ReDim Preserve t2(1 To 11, 1 To x)
For k = 1 To 11: t2(k, x) = t(i, k): Next k: x = x + 1: End If: Next i
Sheets(z).Range("a65536").End(xlUp)(2).Resize(UBound(t2, 2), UBound(t2, 1)) = Application.Transpose(t2)
Erase t, t2: End With: Next c: End With: Beep
End Sub |
Partager