VBA dynamic list

hi,

i am having trouble with trying to figure out how to best approach my problem and hoping someone can provide input.

i have a data dump in sheet 1 with multiple categories repeated. i want first to figure the number of categories and it will great group heading of those categories in next sheet.

then filter the categories and copy sub group to the next sheet under the category

result:
category 1
subgroup
subgroup
subgroup

category 2
subgroup

category 3
subgroup
subgroup



my issue is the number of categories will change all the time and need it dynamic to know how much to add. also the #of subgroup will change as well.
one month category 1 might have 2 subgroup and other month 3. category 2 might have 1 subgroup or 4 the next month.

i have attached example to make it easier to explain.

hoping i can get some guidance on this.

Hi matrix_xrs,
try this

Please Login or Register  to view this content.

Hi Nilem,

that works but i need it do one more thing.

lets say one month there in one category there are 2 subgroups and then following month there are 20, i need it to be able to insert rows. is there a way to determine the number of subgroups and then insert the rows?

example:

month 1 results

row
3 Type: acura
4 blue
5 black
6 white
7 red

next month

row
3 Type: acura
4 blue
5 black
6 white
7 red
8 green
9 orange
10 grey

thanks for your help.

hi nilem,

it also needs to add categories from month to month. some month there might be 4 and another month 6. is there a way to dynamically add categories?
i though the easiest would be to do a pivot of the data and that would be easy way to determine the categories and subgroups.

Maybe this:

Please Login or Register  to view this content.