|
- Sub test()
- Dim i&
- Application.ScreenUpdating = False
- arr = Sheets("一月份").[a2].CurrentRegion
- For i = 2 To UBound(arr)
- arr(i, 8) = arr(i, 5) - arr(i, 7)
- Next
- Sheets("一月份").[h2].Resize(UBound(arr), 1) = Application.Index(arr, , 8)
- Sheets("一月份").[a2].CurrentRegion.Sort _
- key1:=Sheets("一月份").[b2], Header:=xlGuess
- Sheets("一月份").[b2].Offset(i + 2, 0) = "总计"
- Sheets("一月份").[e2].Offset(i + 2, 0) = Application.Sum(Sheets("一月份").[e2].Resize(i, 1))
- Sheets("一月份").[g2].Offset(i + 2, 0) = Application.Sum(Sheets("一月份").[g2].Resize(i, 1))
- Sheets("一月份").[h2].Offset(i + 2, 0) = Application.Sum(Sheets("一月份").[h2].Resize(i, 1))
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|