|
提成也可以集成到循环里的。
- Sub grf()
- Dim sht As Worksheet
- Set d = CreateObject("scripting.dictionary")
- Dim brr(1 To 100, 1 To 20)
- For Each sht In Worksheets
- nm = sht.Name
- If nm Like "第*" Then
- x = Split(nm, "次")(0) & "次活动"
- If Not d.Exists(x) Then
- n = n + 1
- d(x) = n
- brr(n, 1) = n
- brr(n, 2) = x
- End If
- p = d(x)
- If InStr(nm, "缴费") Then '缴费表
- brr(p, 3) = sht.[a2]
- brr(p, 4) = sht.[k5]
- brr(p, 5) = sht.[g5]
- brr(p, 7) = sht.[p5]
- Else '支出表
- brr(p, 8) = sht.[d5]
- brr(p, 10) = sht.[d5]
- End If
- ElseIf nm = "提成库" Then '★★★增加了提成部分,
- crr = sht.Range("a5:i" & sht.[a65536].End(3).Row)
- For i = 1 To UBound(crr)
- x = Split(crr(i, 1), "次")(0) & "次活动"
- If Not d.Exists(x) Then
- n = n + 1
- d(x) = n
- brr(n, 1) = n
- brr(n, 2) = x
- End If
- p = d(x)
- brr(p, 11) = crr(i, 8)
- brr(p, 12) = brr(p, 12) + crr(i, 9)
- Next
- End If
- Next
- If n > 0 Then [a9].Resize(n, 12) = brr
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|