excel表格_excel函数公式大全_execl从入门到精通
excel vba一键汇总多个工作表2024-01-29 19:44:25
系统学习点击下方课程链接,需要素材,关注老师后,下方评论“领取素材”即可
Sub 汇总多个工作表()
Dim sh As Worksheet
Dim 汇总 As Worksheet
Dim lastRow As Long
Dim i As Long
'创建汇总工作表
Set 汇总 = ThisWorkbook.Sheets.Add(After:= _
ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
汇总.Name = "汇总"
'循环遍历所有工作表
For Each sh In ThisWorkbook.Worksheets
'跳过汇总工作表
If sh.Name <> 汇总.Name Then
'复制数据到汇总工作表
lastRow = 汇总.Cells(汇总.Rows.Count, "A").End(xlUp).Row
sh.Range("A2:J" & sh.Cells(sh.Rows.Count, "A").End(xlUp).Row).Copy _
汇总.Range("A" & lastRow + 1)
End If
Next sh
'格式化汇总工作表
汇总.Columns("A:J").AutoFit
汇总.Range("A1:J1").Font.Bold = True
汇总.Range("A1:J1").Interior.ColorIndex = 15
End Sub
标签: 怎么用宏汇总excel