|
本帖最后由 lisachen 于 2017-6-2 11:18 编辑
- Sub lqxs()
- Dim arr, i&, aa, r%, arr1()
- Dim d, ks, js, j&, k, t
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- Sheet1.Activate
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- aa = arr(i, 1) + Split(arr(i, 2), "→")(0)
- If aa <> aa1 Then
- r = r + 1
- ReDim Preserve arr1(1 To r)
- arr1(r) = i
- d(aa & r) = r
- End If
- aa1 = aa
- Next
- k = d.keys: t = d.items
- For i = r To 1 Step -1
- ks = arr1(i)
- If i <> r Then
- js = arr1(i + 1)
- Else
- js = UBound(arr) + 1
- End If
- Rows(js).EntireRow.Insert
- Cells(js, 2) = k(i - 1) & " 小计"
- Rows(js).Font.Bold = True
- Cells(js, 6) = Application.WorksheetFunction.Sum(Range(Cells(ks, 6), Cells(js - 1, 6)))
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码
|
评分
-
查看全部评分
|