部门太多,拆分打印 用VBA好些 每个月都得打印
仅供参考
Sub 拆分()
Dim arr
Dim wb As Workbook
Dim ws As Worksheet
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Set ws = ThisWorkbook.Worksheets("PCR模板")
With Worksheets("数据源")
r = .Cells(.Rows.Count, 2).End(xlUp).Row
arr = .Range("a2:n" & r)
End With
For i = 1 To UBound(arr)
With ws
.Range("c2,c3,e3,g3,c6:g7,b11:g14,L11:m14,p11:Q14").ClearContents
.Range("c2") = arr(i, 14)
.Range("c3") = arr(i, 7)
.Range("e3") = arr(i, 11)
.Range("g3") = arr(i, 13)
.Range("c6") = arr(i, 3)
.Range("c7") = arr(i, 2)
.Range("b11") = arr(i, 4)
.Range("L11") = arr(i, 9)
.Range("p11") = arr(i, 10)
Set wb = Workbooks.Add
With wb
ws.Copy after:=.Worksheets(.Worksheets.Count)
.Worksheets("sheet1").Delete
.SaveAs Filename:=ThisWorkbook.Path & "\拆分信息" & arr(i, 14)
.Close False
End With
End With
Next
Application.ScreenUpdating = True
MsgBox "数据拆分完毕!"
End Sub
部门太多,拆分打印 用VBA好些 每个月都得打印