Populate a table depending on dropdown data selected

[ftrindade]

Hi everyone,

I am creating an excel file to automate different repetitive needed steps when organizing an event. One of the steps is exactly to extract, from a widely populated dropdown list, just few categories of products in order to create a pdf file that will be send to clients with current demand.

I have created different fields - name of company, description - that will upload automatically to the tab to be saved as pdf. What I want to do now, is to select, maybe with a slicer, the categories in demand in a way that, depending on the number of those, a table is automatically created and arranged in a pretty professional way.

1. Deck file where employees must insert data:
MiDeck.jpg

2. Dropdown lists
MiDropdown.jpg

3. PDF File that should be filled automatically
MiPdfFileToBeSent.jpg

Any hints on how to do this? Or maybe some good keywords to search? Tks
F