Sub 求和()
For i = 2 To Sheets.Count
Sheets(i).Select
mm = Cells(Rows.Count, 1).End(xlUp).Row
Range("e" & mm + 1) = Application.Sum(Range("e3:e" & mm))
Range("f" & mm + 1) = Range("e" & mm + 1)
Range("a" & mm + 1) = "合计"
Range("a" & mm + 1 & ":f" & mm + 1).Interior.Color = 5800
nam = nam & " " & Sheets(i).Name
hj = hj & " " & Range("e" & mm + 1)
Next
Dim wk As Worksheet
arr = Split(nam, " ")
att = Split(hj, " ")
Set wk = Worksheets.Add
wk.Name = "总和"
wk.Move after:=Sheets(Sheets.Count)
wk.Range("a1:c1").Merge
wk.Range("a1") = "汽车销售"
wk.Range("a1").Interior.Color = Sheets(1).Range("a1").Interior.Color
wk.Range("a2") = Sheets(1).Range("b2")
wk.Range("a2").Interior.Color = Sheets(1).Range("b2").Interior.Color
wk.Range("b2") = Sheets(1).Range("e2")
wk.Range("b2").Interior.Color = Sheets(1).Range("e2").Interior.Color
wk.Range("c2") = Sheets(1).Range("f2")
wk.Range("c2").Interior.Color = Sheets(1).Range("f2").Interior.Color
For i = 1 To UBound(arr)
wk.Range("a" & i + 2) = arr(i)
wk.Range("b" & i + 2) = att(i)
wk.Range("c" & i + 2) = att(i)
Next
End Sub