Vba for selecting names one by one from the drop down list

Closed
Report
Posts
13
Registration date
Monday February 18, 2013
Status
Member
Last seen
October 1, 2013
-
I created a Report Card using excel for my students' to see his/her marks after each exam. The Excel file contains three sheets. First sheet contains the template of Report Card, Second sheet contains student's personal data (like Admission No, Class-Div, Roll No etc) and the Third sheet contains student's marks and grades. In the first sheet, in front of the `Name of the Student' title/cell, I gave a drop down list (using data validation) i.e. cell H12. In front of next each title of the cell I gave VLOOKUP function. So when I select a student name from the drop down list, then the entire data pertaining to that particular student appears in front of each title. Then I save the file in pdf format. As there are 45 students in one division and we have four divisions of such, more time is needed to generate the Report Card of each student.

How can I select the students' name (one by one) from the drop down list using vba? Is there any code for selecting names (auto select) one by one from the drop down list?