|
本帖最后由 chis3 于 2018-3-28 21:38 编辑
Sub test()
Application.ScreenUpdating = False
Dim arr, i As Byte, j As Integer, brr(), counter As Byte, k As Byte
arr = Range(Range("t1"), Cells(Rows.Count, "x").End(xlUp))
For i = 3 To Sheets.Count
Sheets(i).Activate
For j = 1 To UBound(arr)
If Sheets(i).Name = Val(arr(j, 1)) Then
counter = counter + 1
ReDim Preserve brr(1 To 5, 1 To counter)
For k = 1 To 5
brr(k, counter) = arr(j, k)
Next k
End If
Next j
[a1].Resize(counter, 5) = Application.Transpose(brr)
counter = 0
Erase brr
Next i
Application.ScreenUpdating = True
End Sub
|
|