|
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- For Each sh In Worksheets
- If sh.Name <> "目录" Then
- arr = sh.[a1].CurrentRegion
- For i = 3 To UBound(arr)
- xkey = arr(i, 2) & arr(i, 3) & sh.Name
- d(xkey) = d(xkey) + arr(i, 4) '日期+姓名+项目汇总
- ykey = arr(i, 3)
- d(arr(i, 3)) = d(arr(i, 3)) + arr(i, 4) '姓名汇总
- Next
- End If
- Next
- arr = [a1].CurrentRegion
- For i = 3 To UBound(arr)
- xkey = arr(i, 3) & arr(i, 4) & arr(i, 5)
- arr(i, 6) = d(xkey) '日期+姓名+项目汇总结果
- arr(i, 7) = d(arr(i, 4)) '姓名汇总结果
- Next
- [a1].CurrentRegion = arr
- End Sub
复制代码 |
|