用VB非常简单
Sub 台帐检查统计()
Dim a(), z(), b(1 To 100), c(1 To 100) As String
Dim i, ii As Integer
For ii = 1 To Sheets.Count - 1
Sheets(ii).Select
For i = 1 To 100
ReDim a(1 To i), z(1 To ii)
a(i) = Sheets(ii).Cells(i + 4, 8).Text
b(i) = Sheets(ii).Cells(i + 4, 9).Text
c(i) = Sheets(ii).Cells(i + 4, 10).Text
z(ii) = Sheets(ii).Name
Sheets(Sheets.Count).Cells(i + (ii - 1) * 100, 1) = a(i)
Sheets(Sheets.Count).Cells(i + (ii - 1) * 100, 3) = b(i)
Sheets(Sheets.Count).Cells(i + (ii - 1) * 100, 2) = c(i)
Sheets(Sheets.Count).Cells(i + (ii - 1) * 100, 4) = z(ii)
Next
Next
End Sub
温馨提示:答案为网友推荐,仅供参考