Hi all,

My issue: To try and make a long story short, i have a drop down list to choose the name of an athlete that auto-populates a resistance training template based on their best-efforts on the particular exercises.

For example:

Drop Down Selection: Athlete 1

Bench Press (3x5) - 50 lbs

Back Squat (3x5) - 85 lbs

Drop Down Selection: Athlete 2

Bench Press (3x5) - 100 lbs

Back Squat (3x5) - 160 lbs


As you can see, the selection from the drop down menu dictates what is populated on the sheet.

I would very much like to make it easier to print all training sheets for all 22 athletes on a day-in day-out basis. I believe there is a macro that would allow me to print the 22 different sheets by hitting print one time. If anybody is aware of how to do this, I would greatly appreciate some help, as I really don't understand how macros work for the most part. I would also be very thankful if you could be particularly candid in your response because I still have yet to successfully enter a correct macro into an excel book.


Thank you in advance,

Kevin