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
project 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

Code:
Freshman Amanda
Sophomore Amanda
Junior Amanda

So I would then need the results page to show

Code:
Freshman Amanda Math
Freshman Amanda Philosophy
Freshman Amanda English
Freshman Amanda French
Sophomore Amanda Math
Sophomore Amanda Philosophy
Sophomore Amanda English
Sophomore Amanda French
Junior Amanda Math
Junior Amanda Philosophy
Junior Amanda English
Junior Amanda French

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).

URL to post at ExcelForum (no one has been able to help me yet over
there): http://www.excelforum.com/excel-prog...one-sheet.html

Sample file at: http://www.mediafire.com/?1mf3fzz3qyw

On Jul 12, 2:54*pm, Chase <chasechasech...@gmail.com> wrote:
> 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
> project 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
>
> Code:
> Freshman * * * *Amanda
> Sophomore * * * Amanda
> Junior * * * * *Amanda
>
> So I would then need the results page to show
>
> Code:
> Freshman * * * *Amanda * * * * Math
> Freshman * * * *Amanda * * * * Philosophy
> Freshman * * * *Amanda * * * * English
> Freshman * * * *Amanda * * * * French
> Sophomore * * * Amanda * * * * Math
> Sophomore * * * Amanda * * * * Philosophy
> Sophomore * * * Amanda * * * * English
> Sophomore * * * Amanda * * * * French
> Junior * * * * *Amanda * * * * Math
> Junior * * * * *Amanda * * * * Philosophy
> Junior * * * * *Amanda * * * * English
> Junior * * * * *Amanda * * * * French
>
> 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).
>
> URL to post at ExcelForum (no one has been able to help me yet over
> there):http://www.excelforum.com/excel-prog...ing-student-li...
>
> Sample file at:http://www.mediafire.com/?1mf3fzz3qyw

On the classes sheet, insert col A and use this or a macro
=INDEX('List of People'!A:A,MATCH(B2,'List of People'!B:B,0))
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."