Extract records based on User Form selection

[Aland2929]

I have a user form with a unique list of categories. These categories have sub-categories. Once I select a category on the user form, I would like to extract all the sub-categories for that category? I have attached a test file.
Thanks in advance.TestFile1.xlsm

[nathansav]

Range("B:C").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"OutputRange"), Unique:=True

you were filtering only on the subcats.

[nilem]

maybe so

Please Login or Register  to view this content.

[Aland2929]

Thank you. This works perfectly. But is there a way to update the records without clicking the OK button so the records are updated as you scroll from category to category?

[nilem]

try it

Please Login or Register  to view this content.

[Aland2929]

Thanks very much! I have another question but need to make some adjustments first.

[Aland2929]

Is there a way I could have a second list box on the user form that will populate based on the selection chosen in the first list box? The first list box will have the categories and the second list box the sub-categories. In the spread sheet, I show data based on the selection chosen for category and sub-category. Ideally, I would like to choose a category from the list box and have the sub-categories for that category populate in the 2nd list box. I can then select different sub-categories and different data will be displayed for each unique sub-category. I can deal with the display of data based on the different selections but my problem is how to populate the 2nd list box based on a selection from the 1st list box?
Thanks in advance

[nilem]

try it (see attachment)

[Aland2929]

Brilliant! Thank you very much. That is exactly what I was looking for.

[Aland2929]

When I select an option in Listbox1, is it possible for the first item in Listbox2 to be automatically highlighted as I am linking the selection in the list boxes to different range names. I have attached a sample file.
Thanks in advance.

[Aland2929]

I have managed to partly get this right but when I display the user form the sub-category is not displayed in the cell allocated. It only displays after I Click in the 2nd List box? Any assistance would be appreciated. I have attached the sample file with my changes.
Thanks in advance