Sub actualiser()
ligne = 4
For Each onglet In Range("meslistes")
With Sheets(CStr(onglet.Value))
debut = 2
fin = .Cells(debut, 1).End(xlDown).Row
For i = debut To fin
If .Cells(i, 3) <> "" Or .Cells(i, 3) <> 0 Then
Sheets("PREPARATION").Cells(ligne, 1).Value = .Cells(i, 1).Value
Sheets("PREPARATION").Cells(ligne, 2).Value = .Cells(i, 2).Value
Sheets("PREPARATION").Cells(ligne, 3).Value = .Cells(i, 3).Value
ligne = ligne + 1
End If
Next i
End With
Next onglet
End Sub
Sub effacer()
ligne = 4
fin = Cells(ligne, 1).End(xlDown).Row
Range(Cells(ligne, 1), Cells(fin, 3)) = ""
End Sub
Sub zero()
For Each onglet In Range("meslistes")
With Sheets(CStr(onglet.Value))
debut = 2
fin = .Cells(debut, 1).End(xlDown).Row
For i = debut To fin
.Cells(i, 3) = ""
Next i
End With
Next onglet
End Sub