Simple Macro that prints to pdf using a drop down menu

[controlz]

Hi,
I wanted a simple macro that selects an item from a drop down menu in cell b3 (causing the summary sheet to change), prints the summary range, pdfs the sheet, and then saves it named as a certain cell (g3).
Thank you so much! I'm really struggling!

 

[rpaulson]

here is the code to create the pdf.

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
        Filename:="C:\mypath\"& Range("G3") & ".pdf", _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=False, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=False

 

[controlz]

Thank you so much! How do I get it to loop through all the items in the drop down list?

 

[controlz]

The drop down list is in cell b3 and the source is listed from b20:b149. Thank you! Thank you! Thank you!

 

[rpaulson]

so you want 129 pdf files created??

untested.

for r = 20 to 149
Range("B3") = cells(r,"B")
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
        Filename:="C:\mypath\"& Range("G3") & ".pdf", _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=False, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=False

next r

 

[controlz]

exactly! That works perfectly! Thank you so much for your help on this!