Private Sub Worksheet_Change(ByVal Target As Range)
Ligne = Target.Row
Colonne = Target.Column
If Not Intersect(Target, Range("A2:CC65536")) Is Nothing _
And Target.Count = 1 _
And Target.Value <> 0 Then
Sheets("Sheet2").Cells(Ligne - 1, Colonne).FormulaR1C1 = "=Sheet1!RC/Sheet1!R[1]C"
End If
End Sub