|
参与一下。。。
- Sub ykcbf() '//2024.3.31
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("Sheet1")
- r = .Cells(Rows.Count, 1).End(3).Row
- c = .UsedRange.Columns.Count
- arr = .[a1].Resize(r, c)
- n = Application.WorksheetFunction.Match("年", .Rows(1), 0)
- zy = Application.WorksheetFunction.Match("摘要", .Rows(1), 0)
- je = Application.WorksheetFunction.Match("金额", .Rows(1), 0)
- fp = Application.WorksheetFunction.Match("发票号", .Rows(1), 0)
- End With
- For i = 2 To UBound(arr)
- s = CStr(arr(i, fp))
- d(s) = Array(arr(i, n), arr(i, zy), arr(i, je))
- Next
- On Error Resume Next
- With Sheets("Sheet2")
- r = .Cells(Rows.Count, 2).End(3).Row
- arr = .[a1].Resize(r, 5)
- For i = 2 To UBound(arr)
- s = CStr(arr(i, 2))
- For j = 3 To UBound(arr, 2)
- arr(i, j) = d(s)(j - 3)
- Next
- Next
- .[a1].Resize(r, 5) = arr
- .Cells(r + 1, 4) = "合计"
- .Cells(r + 1, 5).FormulaR1C1 = "=SUM(R2C:R" & "[-1]C)"
- End With
- Set d = Nothing
- MsgBox "OK!"
- End Sub
复制代码
|
|