Printing everything in a dropdown list.

[bclark2]

I am very new to macros so forgive me if I'm over-complicating this. I've tried looking through google searches but either haven't found the answer, or haven't found one that I understood (and therefore didn't know I found the answer.)

On the student tab there is a drop down list (currently populated with 3 names, but eventually would have up to 40). I would like to make a macro attached to a button, that when pushed would select each name in the drop down list and print the associated data. I know how to set a macro to print the selection, but it only prints for one item in the drop down list. Anyone have any idea what I'm doing wrong? Again, if this is really very simple I apologize.

Here is my current macro (created by recording) that prints the area with all the info I want. The dropdown list is located in B2 on a sheet titled Student Report. It references a list of names on a sheet titled Teacher Pathways - 1st. That list is in cells A15-A56.

Sub Student_Report()


  Sheets("Student Report").Select
    Range("A1:M54").Select
    ActiveSheet.PageSetup.PrintArea = "$A$1:$M$54"
    Selection.PrintOut Copies:=1
    Sheets("Student Report").Select


End Sub

Thank you for any help.