Hello everyone,
I submit to you my request for coding in vba that I do not know how to solve.
My project has two sheets, the "Issues" sheet = source sheet, then the "Groups" sheet = destination sheet. In my source sheet "Issus" there are 12 columns and a number of rows in length that changes every week.
The source sheet, groups several data which are separated by empty lines. I put each group with a different color to differentiate them.
The number of lines of each group is variable, this number is indicated in the last line of each group in column "L".
Here is an overview of the "Issues" sheet
What I want to do is sort all of these groups by the number of rows shown in the "L" column.
Unless I'm mistaken, here is the result I need to find in the "Groups" sheet.
I remain at your disposal for further information.
N.B.: given the large amount of data to be processed, I would like to ask you for a code that could process the data fairly quickly.
Thanks for your suggestions.
I submit to you my request for coding in vba that I do not know how to solve.
My project has two sheets, the "Issues" sheet = source sheet, then the "Groups" sheet = destination sheet. In my source sheet "Issus" there are 12 columns and a number of rows in length that changes every week.
The source sheet, groups several data which are separated by empty lines. I put each group with a different color to differentiate them.
The number of lines of each group is variable, this number is indicated in the last line of each group in column "L".
Here is an overview of the "Issues" sheet
ListeSansDoublonsDict.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Jeune | Père | Mère | Eleveur | Age | Volière | Cage | Né(e) | Tours | Information | Elevage | Nombre | ||
2 | AE27-092/2013 F | CF03-156/2011 M | YM856-131/2011 F | Gérard Claude | 10a 0m 0j | 5H | 14 | 04-06-13 | 5T | Mâle | ||||
3 | AE27-093/2013 F | CF03-156/2011 M | YM856-131/2011 F | Gérard Claude | 10a 0m 0j | 5H | 14 | 04-06-13 | 5T | Mâle | ||||
4 | AE27-001/2019 M | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 12 | 19-04-19 | 5T | Femelle | ||||
5 | AE27-002/2019 m | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 12 | 19-04-19 | 5T | Femelle | ||||
6 | AE27-003/2019 m | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 13 | 20-04-19 | 5T | Femelle | 5 | |||
7 | ||||||||||||||
8 | AE27-011/2019 F | PG14-003/2018 M | AE27-003/2018 F | Gérard Claude | 4a 1m 14j | 4H | 11 | 22-04-19 | 5T | Femelle Tte jaune | 1 | |||
9 | ||||||||||||||
10 | AE27-013/2019 M | PG14-048/2016 M | AE27-008/2018 F | Gérard Claude | 4a 1m 14j | 4H | 1 | 22-04-19 | 4T | Mâle Tt jaune | ||||
11 | AE27-014/2019 F | AE27-029/2017 M | PG14-048/2018 F | Gérard Claude | 4a 1m 16j | 4H | 2 | 20-04-19 | 4T | Femelle Tte jaune | ||||
12 | AE27-015/2019 M | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 4H | 6 | 19-04-19 | 4T | Mâle | 3 | |||
13 | ||||||||||||||
14 | AE27-017/2019 F | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 3H | 6 | 19-04-19 | 4T | Femelle Tt jaune - Ptes Flûtes - cris d'appel! | ||||
15 | AE27-018/2019 M | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 4H | 6 | 19-04-19 | 4T | Mâle | ||||
16 | AE27-019/2019 M | AE27-034/2017 M | AE27-034/2018 F | Gérard Claude | 4a 1m 16j | 4H | 8 | 20-04-19 | 4T | Mâle Tâche tête | ||||
17 | AE27-020/2019 M | AE27-034/2017 M | AE27-034/2018 F | Gérard Claude | 4a 1m 16j | 4H | 8 | 20-04-19 | 4T | Mâle Tâche derrière œil et tête - Klingelrol | ||||
18 | AE27-035/2022 M | MN96-005/2021 M | AE27-068/2021 F | Gérard Claude | 0a 11m 23j | 5H | 4 | 13-06-22 | 4T | Mâle Tt jaune | x | |||
19 | AE27-036/2022 M | MN96-005/2021 M | AE27-068/2021 F | Gérard Claude | 0a 11m 23j | 5H | 4 | 13-06-22 | 4T | Mâle Tt Jaune | 6 | |||
20 | ||||||||||||||
21 | AE27-045/2022 M | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 5H | 8 | 25-06-22 | 4T | Mâle Tâche aile droite (n'aime pas être pris en main) | ||||
22 | AE27-046/2022 M | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 5H | 8 | 25-06-22 | 4T | Mâle Tte jaune | ||||
23 | AE27-047/2022 F | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 4H | 8 | 25-06-22 | 4T | Femelle Tte jaune | ||||
24 | AE27-048/2022 F | AE27-006/2021 M | AE27-052/2021 F | Gérard Claude | 0a 11m 8j | 4H | 3 | 28-06-22 | 4T | Femelle Tâche aux 2 ailes | 4 | |||
25 | ||||||||||||||
26 | AE27-001/2023 M | AE27-008/2022 M | AE27-039/2022 F | Gérard Claude | 0a 1m 11j | 5H | 15 | 25-04-23 | 4T | Mâle Tache au dos - Mange seul à 26 jours | 1 | |||
27 | ||||||||||||||
28 | AE27-003/2023 F | AE27-032/2022 M | AE27-026/2022 F | Gérard Claude | 0a 0m 31j | 5H | 12 | 05-05-23 | 4T | Femelle tâche tête | ||||
29 | AE27-004/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle Tâche tête | ||||
30 | AE27-005/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | 3 | |||
31 | ||||||||||||||
32 | AE27-007/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | ||||
33 | AE27-008/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | ||||
34 | AE27-009/2023 M | AE27-022/2022 M | MN96-010/2020 F | Gérard Claude | 0a 0m 14j | 5H | 6 | 22-05-23 | 4T | Mâle | ||||
35 | AE27-010/2023 F | AE27-022/2022 M | MN96-010/2020 F | Gérard Claude | 0a 0m 14j | 5H | 6 | 22-05-23 | 4T | Mâle | 4 | |||
36 | ||||||||||||||
37 | AE27-014/2023 M | AE27-029/2022 M | 207-034/2022 F | Gérard Claude | 0a 0m 13j | 5H | 13 | 23-05-23 | 4T | Mâle | ||||
38 | AE27-018/2023 M | AE27-33/2022 M | AE27-024/2022 F | Gérard Claude | 0a 0m 11j | 5H | 7 | 25-05-23 | 4T | Mâle | 2 | |||
Issus |
What I want to do is sort all of these groups by the number of rows shown in the "L" column.
Unless I'm mistaken, here is the result I need to find in the "Groups" sheet.
ListeSansDoublonsDict.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Jeune | Père | Mère | Eleveur | Age | Volière | Cage | Né(e) | Tours | Information | Elevage | Nombre | ||
2 | AE27-017/2019 F | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 3H | 6 | 19-04-19 | 4T | Femelle Tt jaune - Ptes Flûtes - cris d'appel! | ||||
3 | AE27-018/2019 M | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 4H | 6 | 19-04-19 | 4T | Mâle | ||||
4 | AE27-019/2019 M | AE27-034/2017 M | AE27-034/2018 F | Gérard Claude | 4a 1m 16j | 4H | 8 | 20-04-19 | 4T | Mâle Tâche tête | ||||
5 | AE27-020/2019 M | AE27-034/2017 M | AE27-034/2018 F | Gérard Claude | 4a 1m 16j | 4H | 8 | 20-04-19 | 4T | Mâle Tâche derrière œil et tête - Klingelrol | ||||
6 | AE27-035/2022 M | MN96-005/2021 M | AE27-068/2021 F | Gérard Claude | 0a 11m 23j | 5H | 4 | 13-06-22 | 4T | Mâle Tt jaune | x | |||
7 | AE27-036/2022 M | MN96-005/2021 M | AE27-068/2021 F | Gérard Claude | 0a 11m 23j | 5H | 4 | 13-06-22 | 4T | Mâle Tt Jaune | 6 | |||
8 | ||||||||||||||
9 | AE27-092/2013 F | CF03-156/2011 M | YM856-131/2011 F | Gérard Claude | 10a 0m 0j | 5H | 14 | 04-06-13 | 5T | Mâle | ||||
10 | AE27-093/2013 F | CF03-156/2011 M | YM856-131/2011 F | Gérard Claude | 10a 0m 0j | 5H | 14 | 04-06-13 | 5T | Mâle | ||||
11 | AE27-001/2019 M | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 12 | 19-04-19 | 5T | Femelle | ||||
12 | AE27-002/2019 m | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 12 | 19-04-19 | 5T | Femelle | ||||
13 | AE27-003/2019 m | PG14-001/2016 M | AE27-010/2018 F | Gérard Claude | 4a 1m 17j | 5H | 13 | 20-04-19 | 5T | Femelle | 5 | |||
14 | ||||||||||||||
15 | AE27-045/2022 M | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 5H | 8 | 25-06-22 | 4T | Mâle Tâche aile droite (n'aime pas être pris en main) | ||||
16 | AE27-046/2022 M | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 5H | 8 | 25-06-22 | 4T | Mâle Tte jaune | ||||
17 | AE27-047/2022 F | AE27-024/2021 M | AE27-016+/2020 F | Gérard Claude | 0a 11m 11j | 4H | 8 | 25-06-22 | 4T | Femelle Tte jaune | ||||
18 | AE27-048/2022 F | AE27-006/2021 M | AE27-052/2021 F | Gérard Claude | 0a 11m 8j | 4H | 3 | 28-06-22 | 4T | Femelle Tâche aux 2 ailes | 4 | |||
19 | ||||||||||||||
20 | AE27-007/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | ||||
21 | AE27-008/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | ||||
22 | AE27-009/2023 M | AE27-022/2022 M | MN96-010/2020 F | Gérard Claude | 0a 0m 14j | 5H | 6 | 22-05-23 | 4T | Mâle | ||||
23 | AE27-010/2023 F | AE27-022/2022 M | MN96-010/2020 F | Gérard Claude | 0a 0m 14j | 5H | 6 | 22-05-23 | 4T | Mâle | 4 | |||
24 | ||||||||||||||
25 | AE27-013/2019 M | PG14-048/2016 M | AE27-008/2018 F | Gérard Claude | 4a 1m 14j | 4H | 1 | 22-04-19 | 4T | Mâle Tt jaune | ||||
26 | AE27-014/2019 F | AE27-029/2017 M | PG14-048/2018 F | Gérard Claude | 4a 1m 16j | 4H | 2 | 20-04-19 | 4T | Femelle Tte jaune | ||||
27 | AE27-015/2019 M | AE27-032/2017 M | AE27-007/2018 F | Gérard Claude | 4a 1m 17j | 4H | 6 | 19-04-19 | 4T | Mâle | 3 | |||
28 | ||||||||||||||
29 | AE27-003/2023 F | AE27-032/2022 M | AE27-026/2022 F | Gérard Claude | 0a 0m 31j | 5H | 12 | 05-05-23 | 4T | Femelle tâche tête | ||||
30 | AE27-004/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle Tâche tête | ||||
31 | AE27-005/2023 M | AE27-010/2021 M | MN96-034/2021 F | Gérard Claude | 0a 0m 15j | 5H | 5 | 21-05-23 | 4T | Mâle | 3 | |||
32 | ||||||||||||||
33 | AE27-014/2023 M | AE27-029/2022 M | 207-034/2022 F | Gérard Claude | 0a 0m 13j | 5H | 13 | 23-05-23 | 4T | Mâle | ||||
34 | AE27-018/2023 M | AE27-33/2022 M | AE27-024/2022 F | Gérard Claude | 0a 0m 11j | 5H | 7 | 25-05-23 | 4T | Mâle | 2 | |||
35 | ||||||||||||||
36 | AE27-011/2019 F | PG14-003/2018 M | AE27-003/2018 F | Gérard Claude | 4a 1m 14j | 4H | 11 | 22-04-19 | 5T | Femelle Tte jaune | 1 | |||
37 | ||||||||||||||
38 | AE27-001/2023 M | AE27-008/2022 M | AE27-039/2022 F | Gérard Claude | 0a 1m 11j | 5H | 15 | 25-04-23 | 4T | Mâle Tache au dos - Mange seul à 26 jours | 1 | |||
Groupes |
I remain at your disposal for further information.
N.B.: given the large amount of data to be processed, I would like to ask you for a code that could process the data fairly quickly.
Thanks for your suggestions.