Hello everyone,
I'm working on a dashboard on Excel 365, in which I would like to learn how to add three combo boxes which should filter a Pivot Table, named "Operations" and placed in a Sheet also named "Operations"... Basically, this pivot table shows the name of the products, their respective operations and their work orders. I made three slicers, but what I would really like is having three dependant combo boxes, which can filter the pivot table by typing what I'm looking for.
More specifically, I would like to be able to type the name of the product and/or the work order and find the operations.
Another question inherent to this discussion is: would it be better to use Active X combo boxes of Form control ones? Is it even possible to type something into a Form Control combo box?
I hope I expressed myself well. Please tell me if you don't understand something, I'll try to reformulate.
Thank you very much in advance!
