|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub ujjj()
Dim s As Integer, z As Integer, w As Integer, u As Integer
For s = 1 To 5000 Step 1
If Workbooks("原版模板").Sheet2.Range("A" & s) Like "客户订单:*" Then
For w = 8 To 28 Step 1
u = s + w
If Workbooks("原版模板").Sheet2.Range("A" & u) <> "合计:" Then
Workbooks("原版模板").Sheet2.Range("A" & s).Copy Destination:=Workbooks("原版模板").Sheet3.Range("A65536").End(xlUp).Offset(1, 0)
Workbooks("原版模板").Sheet2.Range("A" & u).Resize(1, 12).Copy Destination:=Workbooks("原版模板").Sheet3.Range("C65536").End(xlUp).Offset(1, -1).Resize(1, 12)
ElseIf Workbooks("原版模板").Sheet2.Range("A" & u) = "合计:" Then
Exit For
End If
Next
End If
Next
End Sub
|
|