Hello, As I am not a vba expert, I am posting my request hoping that an expert will help me find a solution to my problem. In the "B_D" sheet, I have a table of ten columns and many (many) rows whose length varies each year, I would like to group all the rows whose contents of the cell of the 2nd column and that of the cell of the 3rd column are identical with the cells of the following line to the same columns. I prefer (if possible) the use of dictionary(s) given their efficiency in the processing of important data. I add that it would also be desirable (for more visibility) to insert an empty line between each group of data. Sample Data from sheet "B_D"
Desired results, see sheet "Result"
I remain at your disposal for any additional information.
Cheers.
Desired results, see sheet "Result"
I remain at your disposal for any additional information.
Cheers.