Howdy y’all,

So I’m a sports scientist/grad student and am working with GPS data reports for a soccer team.

I have my reports for individual players all set up, and have a drop down of names that I can select from. Once I select a name, the graphs all change and become unique to that athlete.

I’m trying to find a way to write VBA that will cycle through that list of names, select each one, then save the file as a PDF before continuing down the list of names till the end.

Not super familiar with VBA but have some experience.

I’d imagine it’s using a for each loop, but am not familiar with saving things as PDF’s (location etc).

Any help is muey appreciated!