Sub 多表合一表() Sheets("6").Cells.Clear For Each sht In Sheets If sht.Name <> "6" Then K = Sheets("6").Range("A65536").End(xlUp).Row + 1 L = sht.UsedRange.Rows.Count sht.Rows("2:" & L).Copy Sheets("6").Cells(K, 1) End If Next Sheets("6").Range("A1:C1") = Array("列標(biāo)題1", "列標(biāo)題2", "列標(biāo)題3") End Sub |
聯(lián)系客服