Auto-Change Drop-Down Selection and Print Report

[jdppep]

My document contains about 50 locations. These are listed in a drop-down menu and populate a dashboard based on the drop-down selection.

I am looking for a code to automatically change the drop-down selection (starting at the first selection), print to .pdf, save the file and proceed to the next drop-down selection, print to .pdf, save the file, etc.

Thanks!

 

[SirJB7]

Hi, jdppep!
Drop-down selection... but how and from? Control on user form, form control in worksheet, ActiveX control in worksheet, cell with data validation list?
Howewer consider uploading a sample file.
Regards!

 

[kchiba]

Hi jdppep,

Look at the attached file and change to suit.

kanti

 

[jdppep]

This is great! Thanks!

 

[asif]

hm...tthxx