Here is my code. It prints out each iteration of the worksheet but I have to manually input the name and hit enter before it goes to the next iteration.

How to I expand upon the ActiveSheet.PrintOut function so that the name is automated?

I tried to add 
prtofilename:=xName
but this didn't work...?


Sub PsuedoCode()
Dim xName As String
Dim c As Range
Dim MyList As Range
Dim DropRange As Range

'Where is list of names? Change to your worksheet name and range
Set MyList = Worksheets("Customer details").Range("A3:A6")

'Where is dropdown? Change worksheet name and cell number
Set DropRange = Worksheets("Price_List").Range("f6")

Application.ScreenUpdating = False
For Each c In MyList
    xName = c.Value
    DropRange.Value = xName


ActiveSheet.PrintOut


Next

End Sub