Creating A Filtered Subset Of A Data Table Using Controls Instead Of Slicers

[testingcode]

Hello, me again. I've ran into some issues with pulling certain data from a table and was hoping I could recieve some help. It's hard to put into words exactly what I mean, but hopefully an example will get my point across.

Let's say I have the table:

Category:	Part:	Volume:
Box	001	1000
Box	003	3000
Tape	101	500
Scissors	201	300
Box	004	2000
Scissors	203	400
Tape	107	600

and more lines are being added everyday. I have a combobox that chooses the category and a listbox that is synced with the drop down to show all the available parts. Is it possible to link both the listbox and dropdown to the data table to form a new table to make a graph from? Preferably with formulas.

Example being if I choose [Box] with my combobox and choose both [001] and [004] as my part numbers a new/seperate table would be shown as:

Category	Part	Volume
Box	001	1000
Box	004	2000

I could then have a chart showing data from the new table.


I'm basically trying to create a Slicer but with comboboxes and listboxes. Any help is appreciated.

Thanks.