開票金額為0, 不列出來~~
Sub Get_Data()
Dim Arr, xArea As Range, xA As Range, xR As Range, N%, i&, j%, T(7), K%
Call ClearALL
Set xArea = [B1:E13]: Set xA = [B1]
Arr = Range(Sheet1.[A1], Sheet1.[AJ65536].End(xlUp))
Application.ScreenUpdating = False
For i = 2 To UBound(Arr)
If Val(Arr(i, 36)) = 0 Then GoTo 101
For j = 1 To 7
T(0) = Arr(i, Array(9, 5, 16, 36, 20, 3, 1)(j - 1))
If T(0) <> "" Then T(j) = T(0)
Next j
K = K + 1: If K > 1 Then xArea.Copy xA
For Each xR In Union(xA(5, 2).Resize(5), xA(11, 2), xA(11, 4))
N = N + 1: xR = T(N)
Next
Set xA = xA(17): N = 0
101: Next i
End Sub
|