|
Sub test()
Dim A, B(1 To 6, 1 To 9), i, j, s, r
A = Sheets(1).Range("a5").CurrentRegion
r = Sheets(2).Cells(Rows.Count, 2).End(3).Row
For i = 6 To 11
For j = 2 To 6
If A(i, j) = "" Then Exit For
Next j
'如果数据齐全,则添加
If j = 7 Then
s = s + 1
B(s, 1) = r - 1 + s
B(s, 2) = A(3, 7)
B(s, 3) = A(4, 7)
For j = 4 To UBound(B, 2)
B(s, j) = A(i, j - 2)
Next j
End If
Next i
Sheets(2).Rows(r + 1 & ":" & Rows.Count).ClearContents
Sheets(2).Cells(r + 1, 1).Resize(UBound(B), UBound(B, 2)) = B
End Sub
送货单2.rar
(11.38 KB, 下载次数: 156)
|
|