Export some data if a condition is met.

harzer · Friday at 2:32 PM

Hello everyone,
I managed to write a code to find a solution to my problem (the solution I wrote is very basic), but unfortunately it is not fast.
The goal of this code is to export all the values that are less than 0.25 and that are in the range ("M3: AF23"), this Range is variable in line (Horizontally) and in column (Vertically).
What we know about this range is that it always starts at "M3" but we do not know its last column and its last line, hence the need to determine them.
When we find a value < 0.25, we will look for the value that is in the same row of column "L" and will also look for the value that is in the same column in row 2
Let's take an example:
Let's look at the value of the first cell of the Range, it is the cell "M3" which is equal to 8%, it is less than 0.25, so we will retrieve the cell of the same row in column "L" (=ABE27-022/2022 M) and will also retrieve the value of the cell of the same column in row 2 (=ABE27-037/2022 F).
We will do the same for all the cells of the Range ("M3: AF23").
When the data of the Range is not numerous, the Macro works well, the problem is that the macro does not execute quickly when my data is important.
How can you write it so that it is very fast, maybe using arrays like LBound and UBound.
The data in the Range comes from a pivot table, please suggest a solution with a vba code, especially not a solution with power query please.
The desired result is in the columns: ("AH3:AJ390").
Thank you in advance for your contributions.

Here is the code that I have implemented and that I would like to rewrite or improve.

VBA Code:

Sub Exporter_Données()

Dim Sels As Range
Dim Ma_Plage As Range
Dim Cell As Range
Dim Lig_Dest As Long
Dim DerLig As Long
Dim DerCol As Long

Application.ScreenUpdating = False

    DerLig = Range("L" & Rows.Count).End(xlUp).Row
    DerCol = Range("L2").End(xlToRight).Column

    'Effacement des précédentes données
    Range(Cells(3, DerCol + 2), Cells(5000, DerCol + 4)).ClearContents

    Lig_Dest = 3
    Set Ma_Plage = Range(Cells(3, "M"), Cells(DerLig, DerCol))

    For Each Cell In Ma_Plage
        If Cell < 0.25 Then
            Cells(Lig_Dest, DerCol + 2) = Cells(Cell.Row, "L")
            Cells(Lig_Dest, DerCol + 3) = Cells(2, Cell.Column)
            Cells(Lig_Dest, DerCol + 4) = Cell
            Lig_Dest = Lig_Dest + 1
        End If
    Next
Application.ScreenUpdating = True

End Sub

Here is the Range data

copier-ou-transposer-donnees-si.xlsm

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

1

Mère

2

Père

ABE27-037/2022 F

ABE27-038/2022 F

ABE27-017/2023 F

ABE27-023/2023 F

ABE27-026/2022 F

NIM96-010/2021 F

ABE27-012/2024 F

ABE27-014/2024 F

ABE27-019/2024 F

ABE27-023/2024 F

ABE27-035/2024 F

ABE27-036/2024 F

ABE27-044/2024 F

ABE27-046/2024 F

ABE27-047/2024 F

ABE27-060/2024 F

ABE27-078/23-2024 F

ABE27-079/23-2024 F

NIM96-006/2024 F

NIM96-066/2024 F

3

ABE27-022/2022 M

8,00%

4,50%

26,30%

7,00%

0,90%

6,80%

7,70%

26,30%

7,50%

5,50%

28,10%

14,70%

29,40%

5,50%

1,50%

4

ABE27-036/2023 M

2,30%

1,70%

2,10%

4,80%

1,10%

8,50%

1,50%

2,10%

3,50%

5,60%

2,40%

5,50%

3,90%

27,30%

5,20%

5

ABE27-022/2023 M

5,00%

9,80%

26,70%

4,40%

27,00%

10,60%

11,00%

26,70%

4,70%

3,50%

18,00%

14,30%

15,30%

3,50%

8,00%

6

ABE27-035/2022 M

28,10%

15,10%

5,00%

6,70%

2,00%

5,70%

28,50%

5,00%

28,50%

17,40%

11,50%

5,80%

7,30%

15,20%

4,90%

7

LUL59-001/2023 M

0,00%

8

NIM96-020/2023 M

6,60%

3,80%

2,00%

9,60%

0,90%

5,30%

6,40%

2,00%

8,10%

28,70%

3,40%

26,40%

6,30%

7,80%

14,60%

9

ABE27-007/2024 M

2,50%

4,90%

25,20%

2,20%

13,50%

5,30%

5,50%

13,30%

2,30%

1,70%

9,00%

13,10%

7,70%

1,80%

4,00%

10

ABE27-067/2024 M

2,50%

4,90%

13,30%

2,20%

13,50%

5,30%

5,50%

13,30%

2,30%

1,70%

9,00%

7,20%

7,70%

1,80%

4,00%

11

ABE27-016/2024 M

17,40%

28,40%

9,40%

3,50%

8,10%

1,50%

5,50%

11,90%

3,50%

12,80%

23,00%

7,50%

16,10%

6,80%

11,50%

9,80%

12

ABE27-017/2024 M

17,40%

28,40%

9,40%

3,50%

8,10%

1,50%

5,50%

11,90%

3,50%

12,80%

23,00%

7,50%

16,10%

6,80%

11,50%

9,80%

13

ABE27-042/2024 M

17,40%

9,40%

3,50%

8,10%

1,50%

5,50%

11,90%

3,50%

12,80%

28,60%

7,50%

16,10%

6,80%

11,50%

9,80%

14

ABE27-043/2024 M

17,40%

9,40%

3,50%

8,10%

1,50%

5,50%

11,90%

3,50%

12,80%

28,60%

7,50%

16,10%

6,80%

11,50%

9,80%

15

ABE27-033/2024 M

17,40%

9,60%

4,70%

28,30%

1,90%

7,30%

19,50%

4,70%

28,40%

12,80%

8,60%

6,40%

17,90%

10,50%

5,60%

16

ABE27-055/2024 M

2,10%

8,40%

8,30%

3,30%

14,60%

8,30%

4,80%

8,30%

2,70%

3,50%

5,20%

6,60%

2,60%

14,40%

9,90%

17

ABE27-006/2024 M

15,60%

10,00%

18,30%

18,20%

4,30%

21,00%

8,80%

11,90%

18,20%

7,10%

6,40%

16,80%

10,50%

9,80%

8,70%

8,90%

18

ABE27-057/2024 M

5,00%

9,80%

26,70%

4,40%

27,00%

10,60%

11,00%

26,70%

4,70%

3,50%

18,00%

14,30%

15,40%

3,50%

8,00%

19

ABE27-009/2024 M

4,80%

6,50%

15,40%

3,90%

14,60%

18,10%

7,00%

15,40%

4,30%

4,00%

11,40%

9,30%

10,10%

7,00%

5,90%

20

ABE27-010/2024 M

4,80%

6,50%

15,40%

3,90%

14,60%

18,10%

7,00%

15,40%

4,30%

4,00%

11,40%

9,30%

10,10%

7,00%

5,90%

21

NIM96-100/2024 M

0,00%

22

NIM96-008/2021 M

2,00%

27,60%

14,50%

1,70%

28,10%

8,20%

8,10%

14,50%

1,90%

1,50%

14,30%

7,70%

1,30%

1,50%

14,50%

23

ABE27-008/2024 M

4,80%

6,50%

15,40%

3,90%

14,60%

18,10%

7,00%

15,40%

4,30%

4,00%

11,40%

9,30%

10,10%

7,00%

5,90%

Couples

The desired result

copier-ou-transposer-donnees-si.xlsm

AH

AI

AJ

3

ABE27-022/2022 M

ABE27-037/2022 F

8,00%

4

ABE27-022/2022 M

ABE27-038/2022 F

8,00%

5

ABE27-022/2022 M

ABE27-017/2023 F

4,50%

6

ABE27-022/2022 M

ABE27-026/2022 F

7,00%

7

ABE27-022/2022 M

NIM96-010/2021 F

0,90%

8

ABE27-022/2022 M

ABE27-012/2024 F

6,80%

9

ABE27-022/2022 M

ABE27-014/2024 F

7,70%

10

ABE27-022/2022 M

ABE27-035/2024 F

7,50%

11

ABE27-022/2022 M

ABE27-036/2024 F

7,50%

12

ABE27-022/2022 M

ABE27-044/2024 F

5,50%

13

ABE27-022/2022 M

ABE27-060/2024 F

14,70%

14

ABE27-022/2022 M

ABE27-079/23-2024 F

5,50%

15

ABE27-022/2022 M

NIM96-006/2024 F

1,50%

16

ABE27-022/2022 M

NIM96-066/2024 F

1,50%

17

ABE27-036/2023 M

ABE27-037/2022 F

2,30%

18

ABE27-036/2023 M

ABE27-038/2022 F

2,30%

19

ABE27-036/2023 M

ABE27-017/2023 F

1,70%

20

ABE27-036/2023 M

ABE27-023/2023 F

2,10%

21

ABE27-036/2023 M

ABE27-026/2022 F

4,80%

22

ABE27-036/2023 M

NIM96-010/2021 F

1,10%

23

ABE27-036/2023 M

ABE27-012/2024 F

8,50%

24

ABE27-036/2023 M

ABE27-014/2024 F

1,50%

25

ABE27-036/2023 M

ABE27-019/2024 F

2,10%

26

ABE27-036/2023 M

ABE27-023/2024 F

2,10%

27

ABE27-036/2023 M

ABE27-035/2024 F

3,50%

28

ABE27-036/2023 M

ABE27-036/2024 F

3,50%

29

ABE27-036/2023 M

ABE27-044/2024 F

5,60%

30

ABE27-036/2023 M

ABE27-046/2024 F

2,40%

31

ABE27-036/2023 M

ABE27-047/2024 F

2,40%

32

ABE27-036/2023 M

ABE27-060/2024 F

5,50%

33

ABE27-036/2023 M

ABE27-078/23-2024 F

3,90%

34

ABE27-036/2023 M

NIM96-006/2024 F

5,20%

35

ABE27-036/2023 M

NIM96-066/2024 F

5,20%

36

ABE27-022/2023 M

ABE27-037/2022 F

5,00%

37

ABE27-022/2023 M

ABE27-038/2022 F

5,00%

38

ABE27-022/2023 M

ABE27-017/2023 F

9,80%

39

ABE27-022/2023 M

ABE27-026/2022 F

4,40%

40

ABE27-022/2023 M

ABE27-012/2024 F

10,60%

41

ABE27-022/2023 M

ABE27-014/2024 F

11,00%

42

ABE27-022/2023 M

ABE27-035/2024 F

4,70%

43

ABE27-022/2023 M

ABE27-036/2024 F

4,70%

44

ABE27-022/2023 M

ABE27-044/2024 F

3,50%

45

ABE27-022/2023 M

ABE27-046/2024 F

18,00%

46

ABE27-022/2023 M

ABE27-047/2024 F

18,00%

47

ABE27-022/2023 M

ABE27-060/2024 F

14,30%

48

ABE27-022/2023 M

ABE27-078/23-2024 F

15,30%

49

ABE27-022/2023 M

ABE27-079/23-2024 F

3,50%

50

ABE27-022/2023 M

NIM96-006/2024 F

8,00%

51

ABE27-022/2023 M

NIM96-066/2024 F

8,00%

52

ABE27-035/2022 M

ABE27-017/2023 F

15,10%

53

ABE27-035/2022 M

ABE27-023/2023 F

5,00%

54

ABE27-035/2022 M

ABE27-026/2022 F

6,70%

55

ABE27-035/2022 M

NIM96-010/2021 F

2,00%

56

ABE27-035/2022 M

ABE27-012/2024 F

5,70%

57

ABE27-035/2022 M

ABE27-019/2024 F

5,00%

58

ABE27-035/2022 M

ABE27-023/2024 F

5,00%

59

ABE27-035/2022 M

ABE27-044/2024 F

17,40%

60

ABE27-035/2022 M

ABE27-046/2024 F

11,50%

61

ABE27-035/2022 M

ABE27-047/2024 F

11,50%

62

ABE27-035/2022 M

ABE27-060/2024 F

5,80%

63

ABE27-035/2022 M

ABE27-078/23-2024 F

7,30%

64

ABE27-035/2022 M

ABE27-079/23-2024 F

15,20%

65

ABE27-035/2022 M

NIM96-006/2024 F

4,90%

66

ABE27-035/2022 M

NIM96-066/2024 F

4,90%

67

LUL59-001/2023 M

ABE27-037/2022 F

0,00%

68

LUL59-001/2023 M

ABE27-038/2022 F

0,00%

69

LUL59-001/2023 M

ABE27-017/2023 F

0,00%

70

LUL59-001/2023 M

ABE27-023/2023 F

0,00%

71

LUL59-001/2023 M

ABE27-026/2022 F

0,00%

72

LUL59-001/2023 M

NIM96-010/2021 F

0,00%

73

LUL59-001/2023 M

ABE27-012/2024 F

0,00%

74

LUL59-001/2023 M

ABE27-014/2024 F

0,00%

75

LUL59-001/2023 M

ABE27-019/2024 F

0,00%

76

LUL59-001/2023 M

ABE27-023/2024 F

0,00%

77

LUL59-001/2023 M

ABE27-035/2024 F

0,00%

78

LUL59-001/2023 M

ABE27-036/2024 F

0,00%

79

LUL59-001/2023 M

ABE27-044/2024 F

0,00%

80

LUL59-001/2023 M

ABE27-046/2024 F

0,00%

81

LUL59-001/2023 M

ABE27-047/2024 F

0,00%

82

LUL59-001/2023 M

ABE27-060/2024 F

0,00%

83

LUL59-001/2023 M

ABE27-078/23-2024 F

0,00%

84

LUL59-001/2023 M

ABE27-079/23-2024 F

0,00%

85

LUL59-001/2023 M

NIM96-006/2024 F

0,00%

86

LUL59-001/2023 M

NIM96-066/2024 F

0,00%

87

NIM96-020/2023 M

ABE27-037/2022 F

6,60%

88

NIM96-020/2023 M

ABE27-038/2022 F

6,60%

89

NIM96-020/2023 M

ABE27-017/2023 F

3,80%

90

NIM96-020/2023 M

ABE27-023/2023 F

2,00%

91

NIM96-020/2023 M

ABE27-026/2022 F

9,60%

92

NIM96-020/2023 M

NIM96-010/2021 F

0,90%

93

NIM96-020/2023 M

ABE27-012/2024 F

5,30%

94

NIM96-020/2023 M

ABE27-014/2024 F

6,40%

95

NIM96-020/2023 M

ABE27-019/2024 F

2,00%

96

NIM96-020/2023 M

ABE27-023/2024 F

2,00%

97

NIM96-020/2023 M

ABE27-035/2024 F

8,10%

98

NIM96-020/2023 M

ABE27-036/2024 F

8,10%

99

NIM96-020/2023 M

ABE27-046/2024 F

3,40%

100

NIM96-020/2023 M

ABE27-047/2024 F

3,40%

101

NIM96-020/2023 M

ABE27-078/23-2024 F

6,30%

102

NIM96-020/2023 M

ABE27-079/23-2024 F

7,80%

103

NIM96-020/2023 M

NIM96-006/2024 F

14,60%

104

NIM96-020/2023 M

NIM96-066/2024 F

14,60%

105

ABE27-007/2024 M

ABE27-037/2022 F

2,50%

106

ABE27-007/2024 M

ABE27-038/2022 F

2,50%

107

ABE27-007/2024 M

ABE27-017/2023 F

4,90%

108

ABE27-007/2024 M

ABE27-026/2022 F

2,20%

109

ABE27-007/2024 M

NIM96-010/2021 F

13,50%

110

ABE27-007/2024 M

ABE27-012/2024 F

5,30%

111

ABE27-007/2024 M

ABE27-014/2024 F

5,50%

112

ABE27-007/2024 M

ABE27-019/2024 F

13,30%

113

ABE27-007/2024 M

ABE27-023/2024 F

13,30%

114

ABE27-007/2024 M

ABE27-035/2024 F

2,30%

115

ABE27-007/2024 M

ABE27-036/2024 F

2,30%

116

ABE27-007/2024 M

ABE27-044/2024 F

1,70%

117

ABE27-007/2024 M

ABE27-046/2024 F

9,00%

118

ABE27-007/2024 M

ABE27-047/2024 F

9,00%

119

ABE27-007/2024 M

ABE27-060/2024 F

13,10%

120

ABE27-007/2024 M

ABE27-078/23-2024 F

7,70%

121

ABE27-007/2024 M

ABE27-079/23-2024 F

1,80%

122

ABE27-007/2024 M

NIM96-006/2024 F

4,00%

123

ABE27-007/2024 M

NIM96-066/2024 F

4,00%

124

ABE27-067/2024 M

ABE27-037/2022 F

2,50%

125

ABE27-067/2024 M

ABE27-038/2022 F

2,50%

126

ABE27-067/2024 M

ABE27-017/2023 F

4,90%

127

ABE27-067/2024 M

ABE27-023/2023 F

13,30%

128

ABE27-067/2024 M

ABE27-026/2022 F

2,20%

129

ABE27-067/2024 M

NIM96-010/2021 F

13,50%

130

ABE27-067/2024 M

ABE27-012/2024 F

5,30%

131

ABE27-067/2024 M

ABE27-014/2024 F

5,50%

132

ABE27-067/2024 M

ABE27-019/2024 F

13,30%

133

ABE27-067/2024 M

ABE27-023/2024 F

13,30%

134

ABE27-067/2024 M

ABE27-035/2024 F

2,30%

135

ABE27-067/2024 M

ABE27-036/2024 F

2,30%

136

ABE27-067/2024 M

ABE27-044/2024 F

1,70%

137

ABE27-067/2024 M

ABE27-046/2024 F

9,00%

138

ABE27-067/2024 M

ABE27-047/2024 F

9,00%

139

ABE27-067/2024 M

ABE27-060/2024 F

7,20%

140

ABE27-067/2024 M

ABE27-078/23-2024 F

7,70%

141

ABE27-067/2024 M

ABE27-079/23-2024 F

1,80%

142

ABE27-067/2024 M

NIM96-006/2024 F

4,00%

143

ABE27-067/2024 M

NIM96-066/2024 F

4,00%

144

ABE27-016/2024 M

ABE27-037/2022 F

17,40%

145

ABE27-016/2024 M

ABE27-017/2023 F

9,40%

146

ABE27-016/2024 M

ABE27-023/2023 F

3,50%

147

ABE27-016/2024 M

ABE27-026/2022 F

8,10%

148

ABE27-016/2024 M

NIM96-010/2021 F

1,50%

149

ABE27-016/2024 M

ABE27-012/2024 F

5,50%

150

ABE27-016/2024 M

ABE27-014/2024 F

11,90%

151

ABE27-016/2024 M

ABE27-019/2024 F

3,50%

152

ABE27-016/2024 M

ABE27-023/2024 F

3,50%

153

ABE27-016/2024 M

ABE27-035/2024 F

12,80%

154

ABE27-016/2024 M

ABE27-036/2024 F

12,80%

155

ABE27-016/2024 M

ABE27-044/2024 F

23,00%

156

ABE27-016/2024 M

ABE27-046/2024 F

7,50%

157

ABE27-016/2024 M

ABE27-047/2024 F

7,50%

158

ABE27-016/2024 M

ABE27-060/2024 F

16,10%

159

ABE27-016/2024 M

ABE27-078/23-2024 F

6,80%

160

ABE27-016/2024 M

ABE27-079/23-2024 F

11,50%

161

ABE27-016/2024 M

NIM96-006/2024 F

9,80%

162

ABE27-016/2024 M

NIM96-066/2024 F

9,80%

163

ABE27-017/2024 M

ABE27-037/2022 F

17,40%

164

ABE27-017/2024 M

ABE27-017/2023 F

9,40%

165

ABE27-017/2024 M

ABE27-023/2023 F

3,50%

166

ABE27-017/2024 M

ABE27-026/2022 F

8,10%

167

ABE27-017/2024 M

NIM96-010/2021 F

1,50%

168

ABE27-017/2024 M

ABE27-012/2024 F

5,50%

169

ABE27-017/2024 M

ABE27-014/2024 F

11,90%

170

ABE27-017/2024 M

ABE27-019/2024 F

3,50%

171

ABE27-017/2024 M

ABE27-023/2024 F

3,50%

172

ABE27-017/2024 M

ABE27-035/2024 F

12,80%

173

ABE27-017/2024 M

ABE27-036/2024 F

12,80%

174

ABE27-017/2024 M

ABE27-044/2024 F

23,00%

175

ABE27-017/2024 M

ABE27-046/2024 F

7,50%

176

ABE27-017/2024 M

ABE27-047/2024 F

7,50%

177

ABE27-017/2024 M

ABE27-060/2024 F

16,10%

178

ABE27-017/2024 M

ABE27-078/23-2024 F

6,80%

179

ABE27-017/2024 M

ABE27-079/23-2024 F

11,50%

180

ABE27-017/2024 M

NIM96-006/2024 F

9,80%

181

ABE27-017/2024 M

NIM96-066/2024 F

9,80%

182

ABE27-042/2024 M

ABE27-037/2022 F

17,40%

183

ABE27-042/2024 M

ABE27-038/2022 F

17,40%

184

ABE27-042/2024 M

ABE27-017/2023 F

9,40%

185

ABE27-042/2024 M

ABE27-023/2023 F

3,50%

186

ABE27-042/2024 M

ABE27-026/2022 F

8,10%

187

ABE27-042/2024 M

NIM96-010/2021 F

1,50%

188

ABE27-042/2024 M

ABE27-012/2024 F

5,50%

189

ABE27-042/2024 M

ABE27-014/2024 F

11,90%

190

ABE27-042/2024 M

ABE27-019/2024 F

3,50%

191

ABE27-042/2024 M

ABE27-023/2024 F

3,50%

192

ABE27-042/2024 M

ABE27-035/2024 F

12,80%

193

ABE27-042/2024 M

ABE27-036/2024 F

12,80%

194

ABE27-042/2024 M

ABE27-046/2024 F

7,50%

195

ABE27-042/2024 M

ABE27-047/2024 F

7,50%

196

ABE27-042/2024 M

ABE27-060/2024 F

16,10%

197

ABE27-042/2024 M

ABE27-078/23-2024 F

6,80%

198

ABE27-042/2024 M

ABE27-079/23-2024 F

11,50%

199

ABE27-042/2024 M

NIM96-006/2024 F

9,80%

200

ABE27-042/2024 M

NIM96-066/2024 F

9,80%

201

ABE27-043/2024 M

ABE27-037/2022 F

17,40%

202

ABE27-043/2024 M

ABE27-038/2022 F

17,40%

203

ABE27-043/2024 M

ABE27-017/2023 F

9,40%

204

ABE27-043/2024 M

ABE27-023/2023 F

3,50%

205

ABE27-043/2024 M

ABE27-026/2022 F

8,10%

206

ABE27-043/2024 M

NIM96-010/2021 F

1,50%

207

ABE27-043/2024 M

ABE27-012/2024 F

5,50%

208

ABE27-043/2024 M

ABE27-014/2024 F

11,90%

209

ABE27-043/2024 M

ABE27-019/2024 F

3,50%

210

ABE27-043/2024 M

ABE27-023/2024 F

3,50%

211

ABE27-043/2024 M

ABE27-035/2024 F

12,80%

212

ABE27-043/2024 M

ABE27-036/2024 F

12,80%

213

ABE27-043/2024 M

ABE27-046/2024 F

7,50%

214

ABE27-043/2024 M

ABE27-047/2024 F

7,50%

215

ABE27-043/2024 M

ABE27-060/2024 F

16,10%

216

ABE27-043/2024 M

ABE27-078/23-2024 F

6,80%

217

ABE27-043/2024 M

ABE27-079/23-2024 F

11,50%

218

ABE27-043/2024 M

NIM96-006/2024 F

9,80%

219

ABE27-043/2024 M

NIM96-066/2024 F

9,80%

220

ABE27-033/2024 M

ABE27-037/2022 F

17,40%

221

ABE27-033/2024 M

ABE27-038/2022 F

17,40%

222

ABE27-033/2024 M

ABE27-017/2023 F

9,60%

223

ABE27-033/2024 M

ABE27-023/2023 F

4,70%

224

ABE27-033/2024 M

NIM96-010/2021 F

1,90%

225

ABE27-033/2024 M

ABE27-012/2024 F

7,30%

226

ABE27-033/2024 M

ABE27-014/2024 F

19,50%

227

ABE27-033/2024 M

ABE27-019/2024 F

4,70%

228

ABE27-033/2024 M

ABE27-023/2024 F

4,70%

229

ABE27-033/2024 M

ABE27-044/2024 F

12,80%

230

ABE27-033/2024 M

ABE27-046/2024 F

8,60%

231

ABE27-033/2024 M

ABE27-047/2024 F

8,60%

232

ABE27-033/2024 M

ABE27-060/2024 F

6,40%

233

ABE27-033/2024 M

ABE27-078/23-2024 F

17,90%

234

ABE27-033/2024 M

ABE27-079/23-2024 F

10,50%

235

ABE27-033/2024 M

NIM96-006/2024 F

5,60%

236

ABE27-033/2024 M

NIM96-066/2024 F

5,60%

237

ABE27-055/2024 M

ABE27-037/2022 F

2,10%

238

ABE27-055/2024 M

ABE27-038/2022 F

2,10%

239

ABE27-055/2024 M

ABE27-017/2023 F

8,40%

240

ABE27-055/2024 M

ABE27-023/2023 F

8,30%

241

ABE27-055/2024 M

ABE27-026/2022 F

3,30%

242

ABE27-055/2024 M

NIM96-010/2021 F

14,60%

243

ABE27-055/2024 M

ABE27-012/2024 F

8,30%

244

ABE27-055/2024 M

ABE27-014/2024 F

4,80%

245

ABE27-055/2024 M

ABE27-019/2024 F

8,30%

246

ABE27-055/2024 M

ABE27-023/2024 F

8,30%

247

ABE27-055/2024 M

ABE27-035/2024 F

2,70%

248

ABE27-055/2024 M

ABE27-036/2024 F

2,70%

249

ABE27-055/2024 M

ABE27-044/2024 F

3,50%

250

ABE27-055/2024 M

ABE27-046/2024 F

5,20%

251

ABE27-055/2024 M

ABE27-047/2024 F

5,20%

252

ABE27-055/2024 M

ABE27-060/2024 F

6,60%

253

ABE27-055/2024 M

ABE27-078/23-2024 F

2,60%

254

ABE27-055/2024 M

ABE27-079/23-2024 F

14,40%

255

ABE27-055/2024 M

NIM96-006/2024 F

9,90%

256

ABE27-055/2024 M

NIM96-066/2024 F

9,90%

257

ABE27-006/2024 M

ABE27-037/2022 F

15,60%

258

ABE27-006/2024 M

ABE27-038/2022 F

10,00%

259

ABE27-006/2024 M

ABE27-017/2023 F

18,30%

260

ABE27-006/2024 M

ABE27-023/2023 F

18,20%

261

ABE27-006/2024 M

ABE27-026/2022 F

4,30%

262

ABE27-006/2024 M

NIM96-010/2021 F

21,00%

263

ABE27-006/2024 M

ABE27-012/2024 F

8,80%

264

ABE27-006/2024 M

ABE27-014/2024 F

11,90%

265

ABE27-006/2024 M

ABE27-019/2024 F

18,20%

266

ABE27-006/2024 M

ABE27-023/2024 F

18,20%

267

ABE27-006/2024 M

ABE27-035/2024 F

7,10%

268

ABE27-006/2024 M

ABE27-036/2024 F

7,10%

269

ABE27-006/2024 M

ABE27-044/2024 F

6,40%

270

ABE27-006/2024 M

ABE27-046/2024 F

16,80%

271

ABE27-006/2024 M

ABE27-047/2024 F

16,80%

272

ABE27-006/2024 M

ABE27-060/2024 F

10,50%

273

ABE27-006/2024 M

ABE27-078/23-2024 F

9,80%

274

ABE27-006/2024 M

ABE27-079/23-2024 F

8,70%

275

ABE27-006/2024 M

NIM96-006/2024 F

8,90%

276

ABE27-006/2024 M

NIM96-066/2024 F

8,90%

277

ABE27-057/2024 M

ABE27-037/2022 F

5,00%

278

ABE27-057/2024 M

ABE27-038/2022 F

5,00%

279

ABE27-057/2024 M

ABE27-017/2023 F

9,80%

280

ABE27-057/2024 M

ABE27-026/2022 F

4,40%

281

ABE27-057/2024 M

ABE27-012/2024 F

10,60%

282

ABE27-057/2024 M

ABE27-014/2024 F

11,00%

283

ABE27-057/2024 M

ABE27-035/2024 F

4,70%

284

ABE27-057/2024 M

ABE27-036/2024 F

4,70%

285

ABE27-057/2024 M

ABE27-044/2024 F

3,50%

286

ABE27-057/2024 M

ABE27-046/2024 F

18,00%

287

ABE27-057/2024 M

ABE27-047/2024 F

18,00%

288

ABE27-057/2024 M

ABE27-060/2024 F

14,30%

289

ABE27-057/2024 M

ABE27-078/23-2024 F

15,40%

290

ABE27-057/2024 M

ABE27-079/23-2024 F

3,50%

291

ABE27-057/2024 M

NIM96-006/2024 F

8,00%

292

ABE27-057/2024 M

NIM96-066/2024 F

8,00%

293

ABE27-009/2024 M

ABE27-037/2022 F

4,80%

294

ABE27-009/2024 M

ABE27-038/2022 F

4,80%

295

ABE27-009/2024 M

ABE27-017/2023 F

6,50%

296

ABE27-009/2024 M

ABE27-023/2023 F

15,40%

297

ABE27-009/2024 M

ABE27-026/2022 F

3,90%

298

ABE27-009/2024 M

NIM96-010/2021 F

14,60%

299

ABE27-009/2024 M

ABE27-012/2024 F

18,10%

300

ABE27-009/2024 M

ABE27-014/2024 F

7,00%

301

ABE27-009/2024 M

ABE27-019/2024 F

15,40%

302

ABE27-009/2024 M

ABE27-023/2024 F

15,40%

303

ABE27-009/2024 M

ABE27-035/2024 F

4,30%

304

ABE27-009/2024 M

ABE27-036/2024 F

4,30%

305

ABE27-009/2024 M

ABE27-044/2024 F

4,00%

306

ABE27-009/2024 M

ABE27-046/2024 F

11,40%

307

ABE27-009/2024 M

ABE27-047/2024 F

11,40%

308

ABE27-009/2024 M

ABE27-060/2024 F

9,30%

309

ABE27-009/2024 M

ABE27-078/23-2024 F

10,10%

310

ABE27-009/2024 M

ABE27-079/23-2024 F

7,00%

311

ABE27-009/2024 M

NIM96-006/2024 F

5,90%

312

ABE27-009/2024 M

NIM96-066/2024 F

5,90%

313

ABE27-010/2024 M

ABE27-037/2022 F

4,80%

314

ABE27-010/2024 M

ABE27-038/2022 F

4,80%

315

ABE27-010/2024 M

ABE27-017/2023 F

6,50%

316

ABE27-010/2024 M

ABE27-023/2023 F

15,40%

317

ABE27-010/2024 M

ABE27-026/2022 F

3,90%

318

ABE27-010/2024 M

NIM96-010/2021 F

14,60%

319

ABE27-010/2024 M

ABE27-012/2024 F

18,10%

320

ABE27-010/2024 M

ABE27-014/2024 F

7,00%

321

ABE27-010/2024 M

ABE27-019/2024 F

15,40%

322

ABE27-010/2024 M

ABE27-023/2024 F

15,40%

323

ABE27-010/2024 M

ABE27-035/2024 F

4,30%

324

ABE27-010/2024 M

ABE27-036/2024 F

4,30%

325

ABE27-010/2024 M

ABE27-044/2024 F

4,00%

326

ABE27-010/2024 M

ABE27-046/2024 F

11,40%

327

ABE27-010/2024 M

ABE27-047/2024 F

11,40%

328

ABE27-010/2024 M

ABE27-060/2024 F

9,30%

329

ABE27-010/2024 M

ABE27-078/23-2024 F

10,10%

330

ABE27-010/2024 M

ABE27-079/23-2024 F

7,00%

331

ABE27-010/2024 M

NIM96-006/2024 F

5,90%

332

ABE27-010/2024 M

NIM96-066/2024 F

5,90%

333

NIM96-100/2024 M

ABE27-037/2022 F

0,00%

334

NIM96-100/2024 M

ABE27-038/2022 F

0,00%

335

NIM96-100/2024 M

ABE27-017/2023 F

0,00%

336

NIM96-100/2024 M

ABE27-023/2023 F

0,00%

337

NIM96-100/2024 M

ABE27-026/2022 F

0,00%

338

NIM96-100/2024 M

NIM96-010/2021 F

0,00%

339

NIM96-100/2024 M

ABE27-012/2024 F

0,00%

340

NIM96-100/2024 M

ABE27-014/2024 F

0,00%

341

NIM96-100/2024 M

ABE27-019/2024 F

0,00%

342

NIM96-100/2024 M

ABE27-023/2024 F

0,00%

343

NIM96-100/2024 M

ABE27-035/2024 F

0,00%

344

NIM96-100/2024 M

ABE27-036/2024 F

0,00%

345

NIM96-100/2024 M

ABE27-044/2024 F

0,00%

346

NIM96-100/2024 M

ABE27-046/2024 F

0,00%

347

NIM96-100/2024 M

ABE27-047/2024 F

0,00%

348

NIM96-100/2024 M

ABE27-060/2024 F

0,00%

349

NIM96-100/2024 M

ABE27-078/23-2024 F

0,00%

350

NIM96-100/2024 M

ABE27-079/23-2024 F

0,00%

351

NIM96-100/2024 M

NIM96-006/2024 F

0,00%

352

NIM96-100/2024 M

NIM96-066/2024 F

0,00%

353

NIM96-008/2021 M

ABE27-037/2022 F

2,00%

354

NIM96-008/2021 M

ABE27-038/2022 F

2,00%

355

NIM96-008/2021 M

ABE27-023/2023 F

14,50%

356

NIM96-008/2021 M

ABE27-026/2022 F

1,70%

357

NIM96-008/2021 M

ABE27-012/2024 F

8,20%

358

NIM96-008/2021 M

ABE27-014/2024 F

8,10%

359

NIM96-008/2021 M

ABE27-019/2024 F

14,50%

360

NIM96-008/2021 M

ABE27-023/2024 F

14,50%

361

NIM96-008/2021 M

ABE27-035/2024 F

1,90%

362

NIM96-008/2021 M

ABE27-036/2024 F

1,90%

363

NIM96-008/2021 M

ABE27-044/2024 F

1,50%

364

NIM96-008/2021 M

ABE27-046/2024 F

14,30%

365

NIM96-008/2021 M

ABE27-047/2024 F

14,30%

366

NIM96-008/2021 M

ABE27-060/2024 F

7,70%

367

NIM96-008/2021 M

ABE27-078/23-2024 F

1,30%

368

NIM96-008/2021 M

ABE27-079/23-2024 F

1,50%

369

NIM96-008/2021 M

NIM96-006/2024 F

14,50%

370

NIM96-008/2021 M

NIM96-066/2024 F

14,50%

371

ABE27-008/2024 M

ABE27-037/2022 F

4,80%

372

ABE27-008/2024 M

ABE27-038/2022 F

4,80%

373

ABE27-008/2024 M

ABE27-017/2023 F

6,50%

374

ABE27-008/2024 M

ABE27-023/2023 F

15,40%

375

ABE27-008/2024 M

ABE27-026/2022 F

3,90%

376

ABE27-008/2024 M

NIM96-010/2021 F

14,60%

377

ABE27-008/2024 M

ABE27-012/2024 F

18,10%

378

ABE27-008/2024 M

ABE27-014/2024 F

7,00%

379

ABE27-008/2024 M

ABE27-019/2024 F

15,40%

380

ABE27-008/2024 M

ABE27-023/2024 F

15,40%

381

ABE27-008/2024 M

ABE27-035/2024 F

4,30%

382

ABE27-008/2024 M

ABE27-036/2024 F

4,30%

383

ABE27-008/2024 M

ABE27-044/2024 F

4,00%

384

ABE27-008/2024 M

ABE27-046/2024 F

11,40%

385

ABE27-008/2024 M

ABE27-047/2024 F

11,40%

386

ABE27-008/2024 M

ABE27-060/2024 F

9,30%

387

ABE27-008/2024 M

ABE27-078/23-2024 F

10,10%

388

ABE27-008/2024 M

ABE27-079/23-2024 F

7,00%

389

ABE27-008/2024 M

NIM96-006/2024 F

5,90%

390

ABE27-008/2024 M

NIM96-066/2024 F

5,90%

Couples

Kaper · Saturday at 4:45 AM

It's a pitty you don't want/cannot use PQ solution, because it would be just 2 steps. unpivot and filter. In VBA it is a bit longer.
You shall probably also add clearing contents of output range and preformat that range before running code - or leave the format which is already there: (especially column widths and desired percentage format).

VBA Code:

Sub unpivot_with_condition()
Dim lrow As Long, lcol As Long, i As Long, j As Long, counter As Long
Dim rhdrs As Variant, chdrs As Variant, inarr As Variant, outarr() As Variant

With ActiveSheet
  lrow = .Range("L3").End(xlDown).Row
  lcol = .Range("M2").End(xlToRight).Column
  rhdrs = .Range(.Cells(3, "L"), .Cells(lrow, "L"))
  chdrs = .Range(.Cells(2, "M"), .Cells(2, lcol))
  inarr = .Range(.Cells(3, "M"), .Cells(lrow, lcol))
  ReDim outarr(1 To UBound(rhdrs) * UBound(chdrs, 2), 1 To 3)
  For i = 1 To UBound(rhdrs)
    For j = 1 To UBound(chdrs, 2)
      If inarr(i, j) <= 0.25 Then 'check if it needs to be < or <= 0.25
        counter = counter + 1
        outarr(counter, 1) = rhdrs(i, 1)
        outarr(counter, 2) = chdrs(1, j)
        outarr(counter, 3) = inarr(i, j)
      End If
  Next j, i
  .Range("AH3").Resize(counter, 3) = outarr
End With
End Sub

harzer · Saturday at 6:41 AM

Hello Kaper,
Thank you for your feedback and the proposed code, the latter works well and gives me the desired result.
In your message, you tell me that it is a shame not to use a PQ solution. If I asked this, it is for two reasons:
1. I do not know and I have never worked with the PQ.
2. The Range ("L1:AF23") on which we are working is a pivot table, do you think we can use a solution with PQ, with data collected from a pivot table, in the same way if the source data comes from a Normal Range like Range ("L1:AF23"). If it is possible, I am ready to try this solution with PQ.
Do not forget that I am a novice in vba mainly in PQ, I would need some explanations to put the solution with PQ in place.
A big THANK YOU and I await your return.
Greetings.

Export some data if a condition is met.

harzer

Board Regular

Excel Facts

Kaper

Well-known Member

harzer

Board Regular

Similar threads

Forum statistics

Share this page

Export some data if a condition is met.

harzer

Board Regular

Excel Facts

Kaper

Well-known Member

harzer

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock