Combing Student list and Classes they took to one sheet

This is the last step I have in a larger project. Any help would be appreciated. A sample workbook is attached with a desired results tab.

In one sheet (List of People): I have a list of Student Names and each grade level they attended while at my school.
In another sheet (Class Breakdown): I have a list of the kids and the classes they took. One can assume that for the Students that were there for more than one year, they took the same breakdown of classes each year [the Class Breakdown sheet contains no year information, only student and class].

For each entry in 'List of People' I need unique lines for each class that person took. So for example: in 'Class Breakdown' Amanda has taken 4 classes: Math, Philosophy, English, and French. In 'List of People' I have that Amanda went here for 3 years

Please Login or Register  to view this content.

So I would then need the results page to show

Please Login or Register  to view this content.

Any help would be appreciated. It is important to note, that there will also be numbers in the columns to the right of this information (hense the random data in the sample spreadsheet).

Hello minimacros,

Please check your post. I don't see any attached file.

Hello minimacros,

I wanted to ask you about this layout. It seems a little odd that each student has Q1 - Q4 numbers, yet the the classes remain the same for each year while these values change. I have never attended any school where I took the same classes year to year.I am bring this up because if you need yearly information then the code should be setup to do that now rather than later.

Hi minimacros
See if this code does as you require

Please Login or Register  to view this content.

Let me know of issues.
John

Hi minimacros

Option Explicit requires that you declare all your variables. It helps in compiling. If you have variables declared and misspell one, the compiler will throw and error. To read more about the subject, follow this link http://www.cpearson.com/excel/DeclaringVariables.aspx

I believe it affects all procedures in the project, so, if you have undeclared variables in the project, the compiler will find them.

I'm glad the code works for you. If you're satisfied with the solution, please mark your post as solved. A click on the scales would be appreciated.
John