- Sub Macro1()
- Dim arr, brr, d, i&, s&, zf$$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("记账凭证").Range("a3").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 5)
- zf = "库存现金"
- For i = 4 To UBound(arr)
- If arr(i, 3) = zf Then d(arr(i, 1)) = ""
- Next
- For i = 4 To UBound(arr)
- If d.exists(arr(i, 1)) And arr(i, 3) <> zf Then
- s = s + 1
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 2)
- brr(s, 3) = arr(i, 3)
- brr(s, 4) = arr(i, 6)
- brr(s, 5) = arr(i, 5)
- End If
- Next
- Sheets("日记账").Activate
- [c3:g20000] = ""
- Range("c3").Resize(s, 5) = brr
- End Sub
复制代码 |