Populating items from the lists based on conditions in separate worksheet

[Nevermore97]

Hello all,

I am in the process of learning VBA and needed help on the captioned item for one of my self-learning projects.

I have various groups (color, animals, fruits etc.) and trying to populate the list of the components (red, blue, green, lion, tiger, apple, banana etc.) within those groups. My main worksheet ("Main") has Column A with all of the items within the list and Column B that shows which group they pertain to e.g. Cell A2 is Red, Cell B2 is Color, similarly, Cell A5 is Lion, Cell B5 is Animal.

My summary sheet ("Summary") is where I need VBA help. I am looking to have a list of all the colors in the Main worksheet when the Color cell is chosen in the Summary worksheet. So e.g. if users select Fruit in Cell A5 (Input box), all the Rows below that cell automatically populates the list of fruits from Main worksheet.

Really appreciate some guidance in moving in the right direction with this. TIA !

 

[Nevermore97]

At the moment, I can easily populate the items within the sub-group through a pivot table / filter but needed to learn a way to do it through VBA as part of learning. Appreciate any help. Thanks