|
本帖最后由 lsy1133 于 2015-4-7 12:13 编辑
如附件,有许多附表,如何把附表上相同信息汇总到一张表格中?谢谢!
- Sub Macro1()
- Dim arr, brr(1 To 20000, 1 To 2), rng As Range
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To Sheets.Count
- If Sheets(i).Name <> "汇总" Then
- Set rng = Sheets(i).[a:a].Find("应收利息", lookat:=xlWhole)
- arr = rng.CurrentRegion
- For j = 3 To UBound(arr) - 1
- If arr(j, 1) <> "" Then
- s = s + 1
- brr(s, 1) = arr(j, 1)
- brr(s, 2) = arr(j, 4)
- n = n + arr(j, 4)
- End If
- Next
- End If
- Next
- brr(s + 1, 1) = "合计"
- brr(s + 1, 2) = n
- Range("f4").Resize(s + 1, 2) = brr
- End Sub
复制代码
|
|