Sub Macro1()
Dim arr, brr, d, i&, j%, y&
Set d = CreateObject("scripting.dictionary")
Sheets("总表").Activate
arr = Range("a2").CurrentRegion
ReDim brr(1 To UBound(arr), 1 To 8)
y = UBound(arr, 2)
For j = 6 To Sheets.Count
Sheets(j).UsedRange.Offset(2, 0).ClearContents
Next
For i = 3 To UBound(arr)
If arr(i, 9) = "锻压" Then d(arr(i, 1)) = d(arr(i, 1)) & " " & i
Next
a = d.keys: b = d.items
For i = 0 To d.Count - 1
x = Split(b(i))
z = Day(a(i))
For j = 1 To UBound(x)
brr(j, 1) = a(i)
brr(j, 2) = arr(x(j), 8)
brr(j, 3) = arr(x(j), 3)
brr(j, 4) = arr(x(j), 4)
brr(j, 5) = arr(x(j), 5)
brr(j, 6) = arr(x(j), 6)
brr(j, 7) = arr(x(j), 7)
Next
Sheets("" & z).Cells(3, 1).Resize(UBound(x), UBound(brr, 2)) = brr
Next
End Sub
像这样的代码需要怎么修改,才可以是附件的效果。 |