Sub sauvegarde()
Dim dl As Long
Dim i As Integer
With Sheets("BASE")
dl = .Range("b" & Rows.Count).End(xlUp).Row
If Sheets("BASE").Range("a2") = "" Then
MsgBox "veuillez renseigner le nom du site"
End If
If .Range("a2") <> "" Then
Sheets.Add.Move After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = .Range("a2")
Tbl = .Range("B2:H71")
Sheets(Sheets.Count).Range("a1").Resize(UBound(Tbl, 1), UBound(Tbl, 2)) = Tbl
' For i = 1 To dl'recopie les formules
' .Range("B" & i & ":M" & i).Copy Sheets(Sheets.Count).Range("a" & i)
' Columns("A:B").AutoFit
' Next
End If
End With
Recap
RecapSite
' Application.CutCopyMode = False
End Sub
Sub Recap()
Dim Tbl, i As Long, Cel As Range
Tbl = Worksheets("base").Range("B2:H48")
With Worksheets("Recap")
For i = 1 To UBound(Tbl, 1)
For Each Cel In .Range("A2:A71")
If Tbl(i, 1) <> "" And Cel = Tbl(i, 1) Then
Cel.Offset(, 1) = Cel.Offset(, 1) + Tbl(i, 5)
Exit For
End If
Next Cel
Next i
End With
End Sub
Sub RecapSite()
Dim L As Long
With Worksheets("Réc site") 'commencer avec cellules vides sauf entêtes
' Set cel = .Columns(1).Find(Range("base!A2"), LookIn:=xlValues, lookat:=xlWhole) 'si le nom existe,si besoin tu décommentes
' If Not cel Is Nothing Then
' .Range("B" & L) = .Range("B" & L) + Range("base!F71")
' Else
L = .Range("A65536").End(xlUp).Row + 1 'ajoute
.Range("A" & L) = Range("base!A2")
.Range("B" & L) = .Range("B" & L) + Range("base!F71")
' End If
End With
End Sub