|
学习下
Application.ScreenUpdating = False
'On Error Resume Next
Dim i, j, n, m, k As Integer, TB1, TB2 As Worksheet, rng As Range
Set TB1 = Worksheets("标签")
Set TB2 = Worksheets("盘点表")
Set rng = Worksheets("标签模板").Range("1:5")
TB1.Cells.Clear
TB1.Cells.Rows.AutoFit
i = TB2.Cells(Rows.Count, 5).End(xlUp).Row
With TB1
For j = 4 To i Step 3
ri = TB1.Cells(Rows.Count, 2).End(xlUp).Row
If j Mod 3 = 1 Then rng.Copy .Cells(ri + 2, 1)
For k = 1 To 3
.Cells(ri + 4, k * 3) = TB2.Cells(j + k - 1, 4)
.Cells(ri + 5, k * 3) = TB2.Cells(j + k - 1, 6)
.Cells(ri + 6, k * 3) = TB2.Cells(j + k - 1, 3)
Next
Next
End With
TB1.Rows("1:2").Delete
End Sub |
|