excel - How can I filter a pivot table with two combo boxes and subsequently open the corresponding PDF file?

Question

I'm working on a dashboard on Excel 365, in which I would like to learn how to add two combo boxes which should filter a Pivot Table, named "Notes" and placed in a Sheet also named "Notes"... Basically, this pivot table shows the name of the products, their respective operations and their eventual notes. I made two slicers which show the name of the products and the operations, but being a beginner with VBA I just can't make them two combo boxes... What I would like to accomplish is having the possibility to fill the first combo box to find the name of the product and having as a result the operations needed in the second combo box.

Also, if it is possible, I would like to make a button which, if pressed, opens a PDF file whose name is composed by the product's name and its operations (e.g. "Product Name_OP. 10-20"). To make things even harder, the name of the products may have some "." and/or "-"... Since the pivot table contains both the "analyzed" and "to be analyzed" products, I wander if it's better to save the PDF files in just one folder or maybe in two ("Analyzed" and "To be Analyzed"). What do you think about it?

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!

Edit: here's the link to my file. Thank you, Ricardo. Sadly I don't have enough knowledge even to be able to start, but I would like to learn.

https://1drv.ms/x/s!AhEwCXNBeDAygmgOehBugmchzW1F?e=bdDguC

Answer 1

等待大神答复