本帖最后由 看见星光 于 2015-8-1 22:37 编辑
- Sub mml()
- Dim arr, brr, i&, j&, k&, n&, myr&
- myr = ActiveSheet.Index
- ReDim brr(1 To Cells.Rows.Count, 1 To 7)
- For i = 1 To myr - 1
- arr = Sheets(i).[b3].CurrentRegion
- For j = 3 To UBound(arr)
- For n = 4 To UBound(arr, 2)
- If arr(1, n) = "" Then arr(1, n) = arr(1, n - 1)
- If arr(2, n) <> "小计" Then
- k = k + 1
- brr(k, 1) = k
- brr(k, 2) = arr(j, 2)
- brr(k, 3) = arr(j, 3)
- brr(k, 4) = Sheets(i).Name
- brr(k, 5) = arr(1, n)
- brr(k, 6) = arr(2, n)
- brr(k, 7) = arr(j, n)
- End If
- Next
- Next
- Next
- Range("b5:h" & Cells.Rows.Count).ClearContents
- [b5].Resize(k, 7) = brr
- End Sub
复制代码 |