Print report from data validation drop down list into a single merged pdf

[Yustino]

Hi,
I have a file with student names and I have controlled them via data validation list. I need to print all student reports into a single merged PDF with marks and contents for each student from the drop down list shown in its page within a merged PDF. I need a help of a VBA Code to do this task. Document attached.. The Drop down list is on the student name highlighted with colour! Please assist!!

 

[vletm]

Yustino
One possible sample ...
but ... my opinion is that is it useful to select those names from the dropdown ... hmm?
Test this with there hints:
1) Click JINA-cell to [un]select all names with one click
2) Click wanted names (JINA-column) one-by-one -- yellow names are selected
3) Press JINA-cells [ PDF ]-button to create selected (yellow) names PDFs to PDF-folder

(You've to create it Yourself to same folder with this Excel-file)​

4) You can see status of PDF in StatusBar
5) After PDF has created - those names will change to green
6) Repeat steps 1 to 5 as many times as You need

( Not fully tested! )​

 

[Yustino]

I am still missing something here. The report I want to print to PDF is the sheet named CLASS 2 REPORT and it should select the names from drop down list and print the resulting report one by one until all students names are selected. The names to be selected from the drop down list in class 2 report are highlighted with some orange colour

 

[vletm]

Yustino
Few basic question:
Did You test it?
Did You save that file in its folder?
Did You create PFD-folder in previous folder?
Did You read my opinion about using dropdown then there are ... many rows to select?
Did You select any cells eg from row 57 from A-column?
Did that selected cells color change to yellow?
Repeat above selection eg three times eg rows 112, 147 & 222?
Press [ PDF ]-button.
... then there will be soon those four PDFs in that PDF-folder.
If this procedure won't do same result as ... Your idea
... You would continue waiting for other solutions.

 

[Yustino]

Yustino
Few basic question:
Did You test it?
Did You save that file in its folder?
Did You create PFD-folder in previous folder?
Did You read my opinion about using dropdown then there are ... many rows to select?
Did You select any cells eg from row 57 from A-column?
Did that selected cells color change to yellow?
Repeat above selection eg three times eg rows 112, 147 & 222?
Press [ PDF ]-button.
... then there will be soon those four PDFs in that PDF-folder.
If this procedure won't do same result as ... Your idea
... You would continue waiting for other solutions.
[/QUOTE

Thank you indeed. This has solved my issue

 

[vletm]

Yustino
Seems that You missed my questions.
I missed some details, which could make my part more useful.