1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| Sub Test()
Dim NomCli As String
Dim Fact As String
Application.ScreenUpdating = False
Range("C" & Range("C995536").End(xlUp)(1).Row).Select
Do While Left(ActiveCell.Offset(-1, 0).Value, 7) = "Facture"
NomCli = ActiveCell.Value
Fact = ActiveCell.Offset(-1, 0).Value
ActiveCell.Offset(-2, 0).Select
ActiveCell.Offset(0, -1).Value = NomCli
ActiveCell.Offset(0, -2).Value = Fact
If ActiveCell.Row = 2 Then
ActiveCell.Offset(-1, 0).Select
ActiveCell.Offset(0, -1).Value = NomCli
ActiveCell.Offset(0, -2).Value = Fact
Application.ScreenUpdating = True
End
End If
Do While Left(ActiveCell.Offset(-2, 0).Value, 7) <> "Facture"
ActiveCell.Offset(-1, 0).Select
ActiveCell.Offset(0, -1).Value = NomCli
ActiveCell.Offset(0, -2).Value = Fact
Loop
ActiveCell.Offset(-1, 0).Select
Loop
ActiveCell.Offset(0, -1).Value = NomCli
ActiveCell.Offset(0, -2).Value = Fact
Application.ScreenUpdating = True
End Sub |
Partager