|
发表于 2022-6-16 16:39
|
显示全部楼层
本楼为最佳答案
請再測試看看,謝謝
Sub test()
Dim Arr, Brr(1 To 1, 1 To 10), T, T1, n&, n1&, i&, j%
T = Sheet4.Range("B2")
Arr = Sheet1.Range("A1").CurrentRegion
For i = 2 To UBound(Arr)
If Arr(i, 14) = T Then
n = n + 1: Arr(n, 1) = Arr(i, 1)
For j = 4 To 12: Arr(n, j - 2) = Arr(i, j): Next
End If
T1 = Arr(i, 13)
Next
Brr(1, 1) = "Total"
For j = 2 To 10: For i = 1 To n
T = Arr(i, j): If T <> "" Then n1 = n1 + 1: Brr(1, j) = n1
Next: n1 = 0: Next
With Sheet4
.[a4:j20] = ""
.[a4].Resize(n, 10) = Arr
.[f2] = T1
.Cells(n + 6, 1).Resize(1, 9) = Brr
End With
End Sub
|
|