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
| Dim Feuille As Worksheet
Dim a, b, c, d, e, f As Integer
a = 0
b = 0
c = 0
d = 0
e = 0
f = 0
For Each Feuille In ActiveWorkbook.Sheets
If Feuille.Name <> "Résultats individuels" And Feuille.Name <> "Résultats d'ensemble" Then Feuille.Name = Feuille.Cells(17, 5).Value & "#" & Feuille.Cells(19, 5).Value
If Cells(21, 5) = "Business Analyst" Then a = a + 1
If Cells(21, 5) = "Consultant" Then b = b + 1
If Cells(21, 5) = "Senior Consultant" Then c = c + 1
If Cells(21, 5) = "Manager" Then d = d + 1
If Cells(21, 5) = "Senior Manager" Then e = e + 1
If Cells(21, 5) = "Associé" Then f = f + 1
Next Feuille
'Calculs'
Cells(4, 2).Value = Worksheets.Count - 2
Cells(5, 2).Value = WorksheetFunction.Sum(Range(Cells(6, 2), Cells(11, 2)))
Cells(6, 2).Value = a
Cells(7, 2).Value = b
Cells(8, 2).Value = c
Cells(9, 2).Value = d
Cells(10, 2).Value = e
Cells(11, 2).Value = f |
Partager