|
发表于 2014-3-23 10:55
|
显示全部楼层
本楼为最佳答案
本帖最后由 dsmch 于 2014-3-23 11:18 编辑
- 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 10)
- y = UBound(arr, 2)
- For j = 5 To Sheets.Count
- Sheets(j).UsedRange.Offset(2, 0).ClearContents
- Next
- For i = 3 To UBound(arr)
- If arr(i, 9) = "冲压" Or 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), 3)
- brr(j, 3) = arr(x(j), 4)
- brr(j, 4) = arr(x(j), 5)
- brr(j, 5) = arr(x(j), 6)
- brr(j, 6) = arr(x(j), 7)
- brr(j, 8) = arr(x(j), 8)
- brr(j, 9) = arr(x(j), 9)
- Next
- Sheets("" & z).Cells(3, 1).Resize(UBound(x), UBound(brr, 2)) = brr
- Next
- End Sub
复制代码 |
|