Hey all,

New to VBA here but very excited and eager to learn. I have a project in mind I want to work towards and am hoping you guys can point me in the right direction to learn how to accomplish it.

For context, I’m a strength coach and am working on designing a workout program template for the teams I coach. Ideally I’d like to have my team roster in a table with info such as sport, year, injury status, developmental group, and position etc.

At the top of the sheet there’s a cell with a validation drop down of all the names in my roster.

I’d like to learn how to write VBA that could allow me to enter the above parameters and print the same sheet while substituting the names into the cell for only the athletes that match the entered criteria, then print those sheets only.

There would be cells with formulas that populate the top of the sheet with 1 rep max numbers and then those would be referenced by other cells within the sheet. My understanding is that this wouldn’t be an issue as the name changes the 1 rep max values automatically.

I’ve seen some code that uses “ .validation” and am imagining something with a for loop to iterate through the validation range but I’m not sure how to set the criteria or batch printing.

Again, I’m looking for guidance on concepts to learn this rather than someone giving me the answer. I want to understand every bit of code I write.

Thanks all very much and looking forward to learning more about the awesome world of VBA!