I am looking to know how to create new worksheet for every row. I am trying to create a workout sheet for students at my school. I have a database with their max percentages for three lifts and am trying to use these to calculate percentages into a workout for each student.However, I am wondering if I can create a macro which will create a new worksheet for each student and fill in the corresponding max totals into the new worksheet? If this is possible, can someone please instruct me on how to go about programming this. Thank You. I have uploaded a pdf with an example of the list and workout if this will help resolve any problems with how I explained my question.
Bookmarks