Hello-
I'm an English teacher, and VBA is new to me, but I know that Excel can do what I want. I keep a gradebook of all my students electronically, and Column A is their name, while Columns B-M are assignments they complete during the semester. So the primary worksheet is for my eyes only and has everyone's cumulative grades on it. What I'd like to do is be able to populate individual worksheets for each student (using a template perhaps?), naming the sheet with the student's name, and then having the individual assignment grades automatically entered onto that sheet in a different format than the primary.
For instance, the primary sheet would say John Doe|85|100|75
and a worksheet would be created titled John Doe that says
Assignment #1|85
Assignment #2|100
Assignment #3|75
so that I can print these out and give them to my students as a record of their grades.
I'm sure this is a multi-step process, and please keep in mind that I'm a noob, so you will have to tell me how to enter the code into VBA properly. I tried using a tutorial, and I'm generally pretty tech-savvy, but I keep getting a compile error following the tutorial's directions.
Thanks in advance for any advice or code!
I'm an English teacher, and VBA is new to me, but I know that Excel can do what I want. I keep a gradebook of all my students electronically, and Column A is their name, while Columns B-M are assignments they complete during the semester. So the primary worksheet is for my eyes only and has everyone's cumulative grades on it. What I'd like to do is be able to populate individual worksheets for each student (using a template perhaps?), naming the sheet with the student's name, and then having the individual assignment grades automatically entered onto that sheet in a different format than the primary.
For instance, the primary sheet would say John Doe|85|100|75
and a worksheet would be created titled John Doe that says
Assignment #1|85
Assignment #2|100
Assignment #3|75
so that I can print these out and give them to my students as a record of their grades.
I'm sure this is a multi-step process, and please keep in mind that I'm a noob, so you will have to tell me how to enter the code into VBA properly. I tried using a tutorial, and I'm generally pretty tech-savvy, but I keep getting a compile error following the tutorial's directions.
Thanks in advance for any advice or code!