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 31 32 33 34 35
|
Sub tester()
Dim X As Integer, i As Integer, j As Integer, c1 As Range, c As Long
Dim TD As String
Dim PA As String
Dim code As Long
X = Application.WorksheetFunction.CountA(Range("A:A"))
For i = 2 To X
code = Sheets("DATA").Cells(i, 1).Value
Set c1 = Sheets("BASE").Columns(1).Find(code, LookIn:=xlValues)
c = c1.Row
If Sheets("BASE").Cells(c, 1).Value = Sheets("DATA").Cells(i, 1).Value & Sheets("BASE").Cells(c, 6).Value = Sheets("DATA").Cells(i, 6).Value Then
Sheets("DATA").Cells(i, 7).Value = "stable"
Else
If Sheets("BASE").Cells(c, 1).Value = Sheets("DATA").Cells(i, 1).Value & Sheets("BASE").Cells(c, 6).Value <> Sheets("DATA").Cells(i, 6).Value Then
If Sheets("BASE").Cells(c, 4).Value <> Sheets("DATA").Cells(i, 4).Value Then
TD = " Taux de douane different "
Else
TD = " "
End If
If Sheets("BASE").Cells(c, 5).Value <> Sheets("DATA").Cells(i, 5).Value Then
PA = " Prix d'achat different "
Else
TD = " "
End If
Sheets("DATA").Cells(i, 7) = TD & PA
End If
End If
Next i
End Sub |
Partager