Public date_controle, zone_controle, centrale_controle, tag_control, modele_controle
Sub baes_ok()
recherche_tab "OK"
End Sub
Sub baes_hs()
recherche_tab "HS"
End Sub
Sub recherche_tab(Etat As String)
date_controle = Range("date_controle")
zone_controle = Range("zone_controle")
centrale_controle = Range("centrale_controle")
tag_controle = Range("tag_controle")
modele_controle = Range("modele_controle")
Dim sh As Worksheet
Dim c As Range
Set sh = Sheets(centrale_controle)
Set c = sh.Range("A6:A1000").Find(what:=tag_controle, LookIn:=xlValues, lookat:=xlWhole)
If Not c Is Nothing Then
c.Offset(, 1) = modele_controle
c.Offset(, 2) = date_controle
c.Offset(, 3) = Etat
End If
End Sub