Excel VBA taking data from master, create sheets, transfer data

Peccant - Apr 29, 2016 at 09:26 AM
 Blocked Profile - Apr 29, 2016 at 05:09 PM

I am working on an excel project for a college. When recording marks they have a master worksheet with the entire roster of students with grades broken down into projects, tests, exams, and other graded tasks. (so a table with student names in column A, project one grades in column B, etc.)

From there, they create an individual sheet for each student with their own grades broken down in the same categories.

I would like to have a button on the main roster sheet that would copy a sheet template for the individual student pages, create a new sheet with that copy for each student, then input all the data from the main roster into each appropriate sheet.

Hoping there is some way to make this work! Thanks a lot.

1 reply

Blocked Profile
Apr 29, 2016 at 05:09 PM
Oh there is a way with software. Post some code and we can help. where are you stuck?