Sub 按钮68_Click()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i As Integer
i = 1
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "汇总.xls"
Do While Cells(1, i) <> ""
Sheets("sheet6").Select
Cells(1, i).Resize(100, 1).Copy
Windows("CPK.xls").Activate
Sheets(i + 1).Select
Range("A2").Select
ActiveSheet.Paste
i = i + 1
Windows("汇总.xls").Activate
If i + 1 > Workbooks("CPK.xls").Sheets.Count Then
Exit Do
End If
Loop
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub