Sub test()
Dim arrData, Temp(1 To 4, 1 To 4)
Dim i As Long
Application.ScreenUpdating = False
With Sheets("生成记录明细")
arrData = .Range("a1").CurrentRegion
End With
n = 1
Sheets("卡片").Cells.Clear
For i = 2 To UBound(arrData)
Sheets("模版").Range("1:6").Copy
Sheets("卡片").Rows(n).Insert Shift:=xlDown
With Sheets("卡片")
.Cells(n + 2, 2) = "'" & arrData(i, 2)
.Cells(n + 3, 2) = "'" & arrData(i, 3)
.Cells(n + 4, 2) = arrData(i, 4)
.Cells(n + 5, 2) = arrData(i, 5)
.Cells(n + 2, 4) = arrData(i, 6)
.Cells(n + 3, 4) = arrData(i, 7)
.Cells(n + 5, 4) = arrData(i, 8)
End With
n = n + 6
Next
Application.ScreenUpdating = True
End Sub
固定资产编码生成系统.rar
(12.33 KB, 下载次数: 18)