I'm looking for an easy way to take a student's academic plan (for the next 2-4 years) and match the classes that they take with the semester they take it, and then do that for 175 other students and counting. The semesters will change depending on the students, but they all take the same classes with the exception of one elective course.
From what I've read, it seems like it would be a pivot table, but I can't wrap my head around how to make it work. All the files are based off the same template. When a student is beginning this program, their coursework until graduation is mapped out for them. Then, to get an idea of how many students will be in each course each semester, we have a separate spreadsheet that I manually add "1" for each time a semester matches that course.
I've been looking over these forums for the last few days and can't figure out if the answer is a pivot table, VBA to run a folder sweep (all the students' academic plans are in the same folder, with only that file type in there, but the names are either "student name_student#.xls" or "student name_semester.xls" so a bit inconsistent), or just some CSE formula.
For the record, I switched to an anthropology major in college when I got a B in Visual Basic with my parents' help haha. So I'm now pretty far outside my element.
Any help is greatly appreciated, and let me know if more information is needed. If it would help having the template and the current course registration table I am using, I can upload them if I can figure out how.
From what I've read, it seems like it would be a pivot table, but I can't wrap my head around how to make it work. All the files are based off the same template. When a student is beginning this program, their coursework until graduation is mapped out for them. Then, to get an idea of how many students will be in each course each semester, we have a separate spreadsheet that I manually add "1" for each time a semester matches that course.
I've been looking over these forums for the last few days and can't figure out if the answer is a pivot table, VBA to run a folder sweep (all the students' academic plans are in the same folder, with only that file type in there, but the names are either "student name_student#.xls" or "student name_semester.xls" so a bit inconsistent), or just some CSE formula.
For the record, I switched to an anthropology major in college when I got a B in Visual Basic with my parents' help haha. So I'm now pretty far outside my element.
Any help is greatly appreciated, and let me know if more information is needed. If it would help having the template and the current course registration table I am using, I can upload them if I can figure out how.
