|
Sub test() Dim arr arr = Range("A2:Ae" & Range("a65536").End(xlUp).Row) ReDim arrnew(1 To UBound(arr), 1 To UBound(arr, 2)) For i = 1 To UBound(arr) If arr(i, 1) = "101" Or arr(i, 1) = "103" Or arr(i, 1) = "104" Or arr(i, 1) = "105" Or arr(i, 1) = "202" Then K = K + 1 For j = 1 To UBound(arr, 2) arrnew(K, j) = arr(i, j) Next j End If Next i Range("A2").Resize(UBound(arr), UBound(arr, 2)) = arrnew Cells(K + 2, 1) = "合计" For j = 13 To 31 Cells(K + 2, j) = Application.WorksheetFunction.Sum(Range(Cells(2, j), Cells(K + 1, j))) Next j End Sub
|
|