以下是一段 VB 代码,可以将所有 sheet 中的数据合并到第一个 sheet 中:
SubMergeSheets()
Dim ws As Worksheet
Dim DestSheet As Worksheet
Set DestSheet = ThisWorkbook.Sheets(1)
For Each ws In ThisWorkbook.Sheets
If ws.Name <> DestSheet.Name Then
ws.UsedRange.Copy
DestSheet.Cells(DestSheet.Rows.Cou