|
发表于 2022-1-12 19:59
|
显示全部楼层
本楼为最佳答案
本帖最后由 sam-wang 于 2022-1-12 20:46 编辑
請測試看看,謝謝
Sub test()
Dim Arr, T, T1, Brr(1 To 10000, 1 To 13), sh%, i&, n%
T = Sheets(1).[a1]
For sh = 2 To Sheets.Count
With Sheets(sh)
Arr = .Range("a1:l" & .[h65536].End(3).Row)
For i = 1 To UBound(Arr)
T1 = Arr(i, 8): If T1 = "" Then GoTo 99
If T = T1 Then
n = n + 1: For j = 1 To 12: Brr(n, j) = Arr(i, j): Next
Brr(n, 13) = Sheets(sh).Name
End If
99: Next
End With
Next
If n > 0 Then
With Sheets(1)
.Range("a15:m" & .[m65536].End(3).Row).ClearContents
.[a15].Resize(n, 13) = Brr
End With
End If
End Sub
|
|