I have several related sets of data. Any idea how to arrange the macro in
filter following?
Now I have a validation list to select value from Row 1 to 3.
Let say Row 6 to 8 are branches of Row 1, Row 10 & 11 are branches of Row 2
and so on (the number of row in subordinate data are not same).
What I am looking for is when users pick a name in the validation list say
AAA, macro gets the criteria of 111, 222, 333 and use them to filter out non
related data.

Column A Column B
Row 1 AAA Row 6 111
Row 7 222
Row 8 333

Row 2 BBB Row 10 444
Row 11 555

Row 3 CCC Row 14 666
Row 15 777
Row 16 888
Row 17 999