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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
|
Sub Bilan_1()
Sheets("EVRC - Semi-quantitatif").Activate
Range("A4:A6").Copy
Sheets("BILAN EVRC").Activate
Range("A4:A6").PasteSpecial
Sheets("EVRC - Semi-quantitatif").Activate
Range("A22").Copy
Sheets("BILAN EVRC").Activate
Range("A8").PasteSpecial
End Sub
_________________________________________________________________
Sub Bilan_2()
Dim i As Integer
Dim j As Integer
Dim k As Integer
k = 2
i = 1
While Sheets("EVRC - Semi-quantitatif").Cells(8, i) <> Empty
i = i + 1
Wend
For j = 2 To i
If Sheets("EVRC - Semi-quantitatif").Cells(22, j) = "Niveau 0" Or Sheets("EVRC - Semi-quantitatif").Cells(22, j) = "Niveau 1" Then
Sheets("EVRC - Semi-quantitatif").Activate
Sheets("EVRC - Semi-quantitatif").Range(Cells(4, j), Cells(6, j)).Copy
Sheets("BILAN EVRC").Activate
Sheets("BILAN EVRC").Range(Cells(4, k), Cells(6, k)).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
k = k + 1
End If
Next j
End Sub
_________________________________________________________________
Sub bilan_3()
Dim i As Integer
Dim j As Integer
Dim k As Integer
k = 2
i = 1
While Sheets("EVRC - Semi-quantitatif").Cells(8, i) <> Empty
i = i + 1
Wend
For j = 2 To i
If Sheets("EVRC - Semi-quantitatif").Cells(22, j) = "Niveau 0" Or Sheets("EVRC - Semi-quantitatif").Cells(22, j) = "Niveau 1" Then
Sheets("EVRC - Semi-quantitatif").Activate
Sheets("EVRC - Semi-quantitatif").Range(Cells(22, j), Cells(22, j)).Copy
Sheets("BILAN EVRC").Activate
Sheets("BILAN EVRC").Range(Cells(8, k), Cells(8, k)).PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
k = k + 1
End If
Next j
End Sub
_________________________________________________________________
Sub BILAN_EVRC_1()
Call Bilan_1
Call Bilan_2
Call bilan_3
End Sub
_________________________________________________________________
Sub Bilan_4()
Dim l As Integer
Dim m As Integer
Dim n As Integer
n = 8
l = 1
While Sheets("EVRC - Quantitatif").Cells(8, l) <> Empty
l = l + 1
Wend
For m = 2 To l
If Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 2" Or Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 3" Then
Sheets("EVRC - Quantitatif").Activate
Sheets("EVRC - Quantitatif").Range(Cells(4, m), Cells(6, m)).Copy
Sheets("BILAN EVRC").Activate
Sheets("BILAN EVRC").Range(Cells(4, n), Cells(6, n)).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
n = n + 1
End If
Next m
End Sub
_________________________________________________________________
Sub bilan_5()
Dim l As Integer
Dim m As Integer
Dim n As Integer
n = 8
l = 1
While Sheets("EVRC - Quantitatif").Cells(8, l) <> Empty
l = l + 1
Wend
For m = 2 To l
If Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 2" Or Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 3" Then
Sheets("EVRC - Quantitatif").Activate
Sheets("EVRC - Quantitatif").Range(Cells(10, m), Cells(10, m)).Copy
Sheets("BILAN EVRC").Activate
Sheets("BILAN EVRC").Range(Cells(8, n), Cells(8, n)).PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
n = n + 1
End If
Next m
End Sub
_________________________________________________________________
Sub bilan_6()
Dim l As Integer
Dim m As Integer
Dim n As Integer
n = 8
l = 1
While Sheets("EVRC - Quantitatif").Cells(8, l) <> Empty
l = l + 1
Wend
For m = 2 To l
If Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 2" Or Sheets("EVRC - Quantitatif").Cells(10, m) = "Niveau 3" Then
Sheets("EVRC - Quantitatif").Activate
Sheets("EVRC - Quantitatif").Range(Cells(16, m), Cells(16, m)).Copy
Sheets("BILAN EVRC").Activate
Sheets("BILAN EVRC").Range(Cells(9, n), Cells(9, n)).PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
n = n + 1
End If
Next m
End Sub
_________________________________________________________________
Sub BILAN_EVRC_2()
Call Bilan_4
Call bilan_5
Call bilan_6
End Sub
_________________________________________________________________
Sub BILAN_EVRC()
Call BILAN_EVRC_1
Call BILAN_EVRC_2
End Sub |
Partager