|
使用这个代码就可以了
后面的单元格格式需要你自己设置好!!
- Sub CC()
- Dim Arr(), Brr, Hx As Long, X As Long, Lx As Long
- With Sheets("数据区")
- Hx = .Range("A65536").End(xlUp).Row
- Arr = .Range("A3:F" & Hx).Value
- End With
- ReDim Brr(1 To Application.RoundUp(UBound(Arr) / 3, 0) * 5, 1 To 14)
- For X = 1 To UBound(Arr)
- Lx = ((X - 1) Mod 3) + 1
- Lx = Lx + (Lx - 1) * 4
- Hx = Int((X - 1) / 3) + 1
- Hx = Hx + (Hx - 1) * 4
-
- Brr(Hx, Lx) = Arr(X, 1)
- Brr(Hx, Lx + 1) = Arr(X, 4)
- Hx = Hx + 1
- Brr(Hx, Lx) = "订单号"
- Brr(Hx, Lx + 1) = Arr(X, 6)
- Brr(Hx, Lx + 2) = "客户"
- Brr(Hx, Lx + 3) = "21"
- Hx = Hx + 1
- Brr(Hx, Lx) = "*" & Arr(X, 5) & "*"
- Brr(Hx + 1, Lx) = Arr(X, 2)
- Next
- With Sheets("条码标签")
- .Range("A:N").ClearContents
- .Range("A1").Resize(UBound(Brr), UBound(Brr, 2)).Value = Brr
- End With
- End Sub
复制代码 你的效果第34,35 行格式与其它行的格式不统一,这一点需要你自己人工修改
格式设置统一后,用上面的代码就可以了!! |
|