本帖最后由 电子表 于 2014-11-20 15:15 编辑
根据部门拆分表格内容至工作簿,每个部门独立工作簿,以部门来命名。要求格式与表格式相同。请论坛的朋友帮忙看看,谢谢!
Sub Click()
Dim r&, f$, p$
Application.ScreenUpdating = False
Application.DisplayAlerts = False
p = ThisWorkbook.Path & "\"
r = Range("a65536").End(xlUp).Row
Do While r <> 1
r = Cells(r, 1).End(xlUp).Row
f = Cells(r, 1)
Cells(r, 1).CurrentRegion.Copy
Workbooks.Add
ActiveSheet.Paste
ActiveWorkbook.SaveAs p & f
ActiveWorkbook.Close
r = Cells(r, 1).End(xlUp).Row
Loop
MsgBox "ok"
End Sub
根据部门内容拆分表格至工作簿2.rar
(14.71 KB, 下载次数: 41)
|