Hello,
I am new here so I apologize if this was posted before, but I am desperate for a solution.

I have a worksheet with a drop-down list (made from data validation), which pulls data from another worksheet and displays it on the first worksheet. The first worksheet (with the dropdown) is designed to be a document that can be printed out (1 for each item on the dropdown). I am looking for a way to print (or save as a pdf) the worksheet for each of the items on the dropdown rather than saving each one individually). Does anyone know of a way to do this? I can send the file if anyone has any ideas.

Thank you