Sub Incremente() 'Macro - 15/01/17
Dim w As Worksheet, dat$, maxi&, i%, f$, derlig&
For Each w In Worksheets
dat = "1-" & w.Name
If IsDate(dat) Then If CDate(dat) > maxi Then maxi = CDate(dat): i = w.Index
Next
If maxi = 0 Then Exit Sub
Application.Calculation = xlCalculationManual 'évite les recalculs des formules volatiles
Sheets(i).Copy After:=Sheets(i)
With Sheets(i + 1)
.Name = Format(maxi + 31, "mm-yy")
.Visible = xlSheetVisible 'si la feuille est masquée
f = .[F9].Formula
derlig = .Cells.SpecialCells(xlCellTypeLastCell).Row
If Month(maxi + 31) < 12 Then
.Range("F9:F" & derlig).Delete xlToLeft
Else
Application.ScreenUpdating = False
.Range("F9:P" & derlig).Insert xlToRight 'insertion de 11 colonnes pour en faire 14
.Range("T9:AG" & derlig).Copy .[F9] '14 colonnes
End If
.[F9] = f
End With
Application.Calculation = xlCalculationAutomatic 'recalcul de toutes les feuilles
End Sub