程序如下:
Sub 宏()Dim i As Integer, j As Integer, k As IntegerFor i = 4 To 41 k = Cells(Rows.Count, i).End(xlUp).Row Range(Cells(k - 4, i), Cells(k, i)).Select Selection.Copy Cells(1, i).Select ActiveSheet.PasteNextEnd Sub