|
- Sub 批建工作表()
- Dim date1, date2
- Dim s, y, m, d, i, j
- '求复制份数,也就是下月天数(d)
- s = Mid(Sheets(1).Range("a1"), 11, 10)
- date1 = CDate(s)
- If Month(date1) = 12 Then
- y = Year(date1) + 1
- m = 1
- Else
- y = Year(date1)
- m = Month(date1) + 1
- End If
- date2 = DateSerial(y, m, Day(date1))
- d = DateDiff("d", date1, date2)
- '建表
- Application.ScreenUpdating = False
- For i = 1 To d
- Sheets.Add after:=Sheets(Sheets.Count)
- Sheets("模板").Cells.CurrentRegion.Copy Destination:=ActiveSheet.Range("A1")
- s = "喵喵啤酒完成量统计(" & y & "/" & m & "/" & i & ")(张三)"
- ActiveSheet.Range("A1") = s
- For j = 1 To 5
- ActiveSheet.Columns(j).ColumnWidth = Sheets("模板").Columns(j).ColumnWidth
- Next j
- ' ActiveSheet.Name = "完成量统计" & y & "." & m & "." & i
- ActiveSheet.Name = i
- Next i
- End Sub
复制代码
附件3.rar
(10.16 KB, 下载次数: 72)
|
|