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
| Sub match()
Dim Var As Variant, Nom As String, Prenom As String, Groupe As String, Repertoire As String
''''''Worksheets("sheet3").Select
''''''Range("A1").Select
Worksheets("sheet1").Activate
Range("a2:a100").Select
For Each a In Selection
Nom = Range(a.Address)
couleur = Range(a.Address).Offset(0, 1)
Var = Application.Index(Worksheets("sheet2").Range("A1", "A100"), Application.match(a, Worksheets("sheet2").Range("A1", "A100"), 0), 1)
If Not IsError(Var) Then
Worksheets("sheet2").Select
''''''''Range("A2").Select
ActiveCell.Value = Var
ActiveCell.Offset(0, 1).Value = couleur
''''''''ActiveCell.Offset(1, 2).Value = Nom
''''''''ActiveCell.Offset(0, 1).Select
Worksheets("sheet1").Activate
End If
Next a
End Sub |
Partager