How to make workbook autocreate new sheet every month with data
Closed
liam8671
Posts
2
Registration date
Thursday 24 August 2017
Status
Member
Last seen
24 August 2017
-
24 Aug 2017 à 12:52
liam8671 Posts 2 Registration date Thursday 24 August 2017 Status Member Last seen 24 August 2017 - 24 Aug 2017 à 14:39
liam8671 Posts 2 Registration date Thursday 24 August 2017 Status Member Last seen 24 August 2017 - 24 Aug 2017 à 14:39
Related:
- How to make workbook autocreate new sheet every month with data
- How to copy data from one excel sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Linkedin learning cost per month - Guide
- How to transfer data from one Excel sheet to another? - Guide
- Little alchemy cheat sheet - Guide
1 response
liam8671
Posts
2
Registration date
Thursday 24 August 2017
Status
Member
Last seen
24 August 2017
24 Aug 2017 à 14:39
24 Aug 2017 à 14:39
Update,
I am using the following code and it makes a new sheet every month.
Sub AddMonthWkst()
Dim ws As Worksheet
Dim strName As String
Dim bCheck As Boolean
On Error Resume Next
strName = Format(Date, "yyyy_mmmm")
bCheck = Len(Sheets(strName).Name) > 0
If bCheck = False Then
Set ws = Worksheets.Add(Before:=Sheets(1))
ws.Name = strName
End If
End Sub
But i was hoping when it made the new sheet that it would copy info from the previous months sheet.
I am using the following code and it makes a new sheet every month.
Sub AddMonthWkst()
Dim ws As Worksheet
Dim strName As String
Dim bCheck As Boolean
On Error Resume Next
strName = Format(Date, "yyyy_mmmm")
bCheck = Len(Sheets(strName).Name) > 0
If bCheck = False Then
Set ws = Worksheets.Add(Before:=Sheets(1))
ws.Name = strName
End If
End Sub
But i was hoping when it made the new sheet that it would copy info from the previous months sheet.
