Printing results from a drop-down list

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

Thank you, here is the file. I am looking to print the worksheet "Scorecard" (a1:q39, selected print area) for each value in the dropdown menu on the same worksheet.

Thank you so much for the feedback, but how would I print all? This may be obvious, but I'm new to anything involving visual basic. If I go to the print option, I only see how to print the current page.

For Dim MyPath As String ' Path to where you want the PDF files (currently same path as spreadsheet)

Do I put an actual file path hyperlink to a folder?

Dim MyFile As String ' File name of the PDF file

Is there a way to have the files save as the value shown in the dropdown menu, or another piece of data?

Awesome! I was able to print these pdfs to a directory, I just have a question about the naming. I think I see that the name is determined here:

MyFile = sh.Cells(i, "A") & ".pdf"

Is there a way that the naming format could be C12_C10 from the "scorecard " sheet (or Column A_Column B from the "month data" sheet)?

dlflak,

The sheet I sent you actually had the real column B deleted, since it has proprietary information. The actual column B will be the actual supplier names, and will not have any "N/A's".

So I see that MyFile = sh.Cells(i, "A") & ".pdf" [name of file will be Supplier ID]
and
MyFile = sh.Cells(i, "B") & ".pdf" [name of file will be supplier name] name the pdf as column A and B from "Month Data" sheet respectively.

Do you know of a way to use both in the name (possibly separated by and underscore or hyphen)? Example File Name: 000001_Unnamed Supplier

Thank you dflak, this works exactly as I would hope.

I do have one bonus question, but I could live with what we already have if this didn't work. Column A is formatted as custom cell type to make sure there are enough digits when displayed in excel. Many of the #'s begin with a zero, and excel will show them without the first zero if not formatted this way. I noticed the pdf's saving do not include the zero in the front of the number. Do you know of any way to keep the formatting while naming? Thank you again

Thank you, this appears to be working correctly. I am however getting a saving error when running the macro by the time it gets to the 45th line. When I click "debug", the macro screen highlights this section in yellow:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
MyPath & "\" & MyFile, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False

I did not get an error when running through all rows with what you sent me on Friday, before making the changes to naming convention. Are these changes no longer consistent with the section pasted above? IS there a reason why there would only be in error after 45 rows?

I just realized that the name that it stopped at has a / (slash) in it. Is it not possible at all to have slashes as a file name? I'm guessing that is more of a pdf naming issue than a macro issue. I can simply change the names that have slashes, but I am trying to keep naming the same across multiple databases.

Thank you! You are a wizard!