Organize tables by type and date

Good afternoon everybody! I have 02 tables, which I need to analyze and consolidate the values ​​by ACTIVE and TYPE, separating the values ​​by 31/12/2021 and 31/12/2022. I have code that works correctly until halfway through, then it returns wrong values. I've tried everything, but I couldn't identify the code error. Would anyone know where I went wrong?
To make it easier I'm posting the spreadsheet with the tables and the code to test.

Anyone who can help me, I'm immensely grateful.

Note: In respect of the rules, I inform you that this question is only posted here.

When your loop goes thru table 1, your loop goes from 1 to tabela1.Rows.Count

However, if you check to see the value of tabela1.Rows.Count it's only 14 because your table is set to 14 rows.. so to properly loop thru the table you would need to set your loop from 5 to (tabela1.Rows.Count + 5) or you could use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

For example;

Please Login or Register  to view this content.

I only checked that first loop but my guess is the same problem applies to the other table's loop as well

I couldn't tell what the issue was so instead I wrote a solution with a scripting dictionary that ensures you end up with a unique list of combinations. The code then populates the array with the relevant data. I commented the code to describe what it does.

Please Login or Register  to view this content.

maníaco, your code worked perfectly! Thank you very much!