|
1、不好意思,那个看错了,已经修改好了。(建议你以后求助,附件中有具体数据,方便写代码的人调试程序);
2、已经在保存加入删除、订单号变下一个了;请查看。- Sub 汇总()
- Dim drow%, drow1%, i%, j%, k%, Arr, Brr(1 To 100, 1 To 10)
- j = 1
- With Worksheets("入库单输入与打印")
- drow = .[a4].End(4).Row
- Arr = .Range("a5:g" & drow)
- For i = 1 To UBound(Arr)
- Brr(j, 1) = .[e2]: Brr(j, 2) = .[b2]: Brr(j, 3) = .[b3]
- Brr(j, 4) = Arr(i, 6): Brr(j, 10) = Arr(i, 7)
- For k = 1 To 5
- Brr(j, 4 + k) = Arr(i, k)
- Next
- j = j + 1
- Next
- .[b2] = Left(.[b2], 7) & (--Right(.[b2], 4) + 1)
- Union(.Range("a5:g13"), .Range("b3"), .Range("e2:e3")).ClearContents
- End With
- With Worksheets("入库单汇总表")
- drow1 = .Cells(.Rows.Count, 1).End(3).Row
- .Cells(drow1 + 1, 1).Resize(j, 10) = Brr
- End With
- End Sub
- Sub 清除()
- With Worksheets("入库单输入与打印")
- Union(.Range("a5:g13"), .Range("b2:b3"), .Range("e2:e3")).ClearContents
- End With
- End Sub
复制代码 |
|