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
Bookmarks