Print to PDF from Data Validation Drop Down

[Chelsea0890]

I am trying to Print to PDF from a data validation list.
I have a pay summary sheet that auto fills when i select the employees name from a drop down list in Cell C6. I need to be able to print off each persons pay summary without having to manually select each persons name
Currently i have a macro for the Print to PDF but have to select from the drop down each time. Is there a macro that will run through the whole data validation list?

The Data validation is in cell C6.

Thanks in Advance!
Chelsea

 

[Kenneth Hobson]

Welcome to the forum!

Did you need each one as a pdf or all as one pdf?

For the latter case, here is an example. https://www.dropbox.com/s/xh85s0l4o0bbwgd/PaySlips.xlsm?dl=0

For the case of one each, one can simply iterate each item in the named range. Since that is unlikely to change in the data validation list, you can hard code that in. I guess that you have a sheet change event to trigger the pdf creation.

 

[Chelsea0890]

I need each PDF saved seperately. They have payment details that need to be sent to individual employees.

 

[Kenneth Hobson]

Change the myList to the named range in your data validation. Run from the activesheet with C6 list.

Sub Main()
  Dim c As Range
  For Each c In myList
    Range("C6").Value2 = c
  Next c
End Sub