I am doing this for a sports team. trying to speed up the printing process. normally if I have to print a specific sheet of workouts. lets say sheet 2, I have to go back to sheet 1 click on the dropdown list choose a new athlete then go back to sheet 2 and print. when teams get really big this takes awhile
I am trying to create a Macro that allows me to print sheet 2 but also prints it for every athlete on the drop down list.
can anyone guide me on how to do this if it is possible.
I have seen similar macros on here but haven't been able to change the code to work for my data
Bookmarks