1. excel表格如何并列
我只能一个BOOK中的所有数据来合并,300个BOOK一起合自并不会,百可能再加个什么东东度,但我不会,
Sub 汇总()
Sheets.Add
With ActiveSheet
.Name = "汇总表" & Format(Now, "hhmmss")
For Each s In ThisWorkbook.Sheets
s.UsedRange.Copy .Cells(.UsedRange.Rows.Count + 1, 1)
Next
End With
End Sub