|
发表于 2016-4-6 14:13
|
显示全部楼层
本楼为最佳答案
本帖最后由 sry660 于 2016-4-6 14:38 编辑
- Sub 出库单打印()
- Dim arr, i&, j&, x, d, brr, n, kh, dh
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets(1).[a1].CurrentRegion
- For i = 2 To UBound(arr)
- x = arr(i, 1): d(x) = ""
- Next
- For Each x In d.keys
- ReDim brr(1 To UBound(arr), 1 To 7)
- For i = 2 To UBound(arr)
- If arr(i, 1) = x Then
- kh = arr(i, 4): dh = x 'kh为客户名称,dh为单号
- n = n + 1
- brr(n, 1) = arr(i, 2): brr(n, 2) = arr(i, 3)
- For j = 3 To 7
- brr(n, j) = arr(i, j + 2)
- Next
- End If
- Next
- With Sheets(2)
- .[a5:g13].ClearContents
- .[b3] = kh: .[g3] = dh
- .[a5].Resize(n, 7) = brr
- .[a2:g15].PrintPreview
- '.[a2:g15].PrintOut
- End With
- Erase brr
- n = 0
- Next
- End Sub
复制代码 |
|