|
Private Sub CommandButton1_Click()
Sheet1.[m6:m100].ClearContents '清除总表M列数据
Dim arr(1 To 12)
r = 6
For x = 2 To Sheets.Count '第2、3、4页循环
For i = 1 To 12 '每页的常用数据进数组
arr(i) = Sheets(x).Cells(4, i)
Next
For j = 1 To Sheets(x).Range("N65536").End(3).Row
Sheet1.Cells(r, 13) = Sheets(x).Cells(j, 14) '每页的N列数据放在总表M列
Sheet1.Cells(r, 1) = arr(1) '根据M列数据和数组采集的常规数据填表
Sheet1.Cells(r, 2) = Mid(Sheet1.Cells(r, 13), 1, 5)
Sheet1.Cells(r, 3) = Mid(Sheet1.Cells(r, 13), 8, 3) / 10 & "度"
Sheet1.Cells(r, 4) = arr(4)
Sheet1.Cells(r, 5) = arr(9)
Sheet1.Cells(r, 6) = arr(10)
Sheet1.Cells(r, 7) = Mid(Cells(r, 13), 11, 10)
Sheet1.Cells(r, 8) = Mid(Sheet1.Cells(r, 13), 17, 2) + 2000 & "年" & Mid(Sheet1.Cells(r, 13), 19, 2) & "月"
Sheet1.Cells(r, 9) = Mid(Sheet1.Cells(r, 13), 23, 2) + 2000 & "年" & Mid(Sheet1.Cells(r, 13), 21, 2) & "月"
Sheet1.Cells(r, 10) = arr(6)
Sheet1.Cells(r, 11) = arr(5)
r = r + 1
Next
Next
'加表尾(省略)
End Sub
|
|