- Sub 汇总1()
- Dim brr(1 To 9999, 1 To 5)
- For Each sht In Sheets
- If InStr(sht.Name, "汇总") = 0 And sht.Name <> "其他" Then
- arr = sht.[a1].CurrentRegion
- For i = 2 To UBound(arr, 2)
- If arr(2, i) = "开票情况" Then j = i: Exit For
- Next
- For i = 3 To UBound(arr)
- If Len(arr(i, 1)) And InStr(arr(i, 1), "合计") = 0 Then
- m = m + 1
- brr(m, 1) = sht.Name
- brr(m, 2) = arr(i, 1)
- brr(m, 3) = arr(i, 5)
- brr(m, 4) = arr(i, j - 1)
- brr(m, 5) = arr(i, j)
- End If
- Next
- End If
- Next
- If m Then
- [a3].Resize(m, 5) = brr
- [a3].Resize(m, 5).Borders.LineStyle = xlContinuous
- End If
- End Sub
复制代码 |