Loop filter multiple criteria different columns

Hello Team

I'm struggling with this one..
trying to create a loop that

1. Make 'unique values' list of MAIN category
2. Filter the table based on that list
3. Select it's SUB category and make a 'unique values' list of it
4. Filter based on the SUB category list and run the code
5. Start over with the next value of MAIN category

This is my code:

Please Login or Register  to view this content.

While it's running Ok on the first MAIN Category value,
It fails to continue to the next one.


Can you help me spot the problem?

Many thanks,
Amit.

Attach a workbook with at least a sample of the data and I'll take a look. You will always get faster responses when you provide a sample workbook rather than require people to recreate your data from an explanation or by guessing.