Print multiple files by cycling through names in dropdown list

I'm assuming this will need some kind of macro (but I really don't know) so I've posted it here. I'm using Excel 2016.

On my spreadsheet I have a range, say, A172:F179.
A172 contains a dropdown, which has names in a class.
When I select a different name, the info in the other cells in the range changes automatically.

What I've been doing is selecting one name at a time, then selecting the range, then going to "Print", then printing a pdf. I repeat this for every student in the class.

The pdf gets named as follows:
StudentLastName StudentFirstName - SubjectName - AssessmentTitle.pdf

eg. Gates Bill - Year 10 Maths - Indices Test.pdf

I would like to know if there's a way I can automate this process, presumably by using a macro. I know what macros are but I'm not super-skilled with them.

To be clear, the end result would be a folder (which already exists) with pdf files (one for each student). Each file would be correctly named, and when it was opened it would show the information which was on the range corresponding to that name. I'd be really grateful for any help or pointers. Thanks.

OK, well after doing a lot of research and fiddling around, I managed to make this work. I'm posting it here in case others want to know how. I'm sure it's not the most elegant or efficient code but it does the job perfectly. I don't know how to make the title say "Solved" now.

Please Login or Register  to view this content.