点击文件名下载附件
Sub 分类汇总()
Dim x As Integer, m1 As Integer, m2 As Integer
Dim k As Integer
m1 = 2
For x = 2 To 1000
If Cells(x, 1) = "" Then Exit Sub
If Cells(x, 1) <> Cells(x + 1, 1) Then
m2 = x
Rows(x + 1).Insert
Cells(x + 1, "a") = Cells(x, "a")
Cells(x + 1, "f") = "=sum(f" & m1 & ":f" & m2 & ")"
Cells(Sheets(1).Range("a1").End(xlDown).Row + 1, 1) = Sheets(2).Cells(x + 1, "a").Value
Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2) = Sheets(2).Cells(x + 1, "f").Value
'(我想把汇总的项目添加到一张新表中,于是新添了2行代码,调试没有错误,但是为什么sheet1中没有数据??)
x = x + 1
m1 = m2 + 2
End If
Next x
End Sub