vba for selecting names one by one from the drop down list (data validation)

[jinoob]

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?

[Solus Rankin]

If you have a list of students on one sheet then you could bypass the drop-down and loop through the list.

[jinoob]

i attached my experiment.

[jaslake]

Hi jinoob

Welcome to the Forum!

This Code will cycle through all the Names and insert it into Cell H12 of Marks Sheet.

Please Login or Register  to view this content.

Where do you wish the PDF files to be saved? If you wish them to be saved to the same Folder as the Workbook that's running the Code try this

Please Login or Register  to view this content.