Taking Flat Data in Excel and Making it Relational in Word
 

Hi Programmers--In sheets set up with last and first names in cols B
and C, dates in row 12, and 2 rows of data for each name (2 cells of
data for each date), is there a way to output values only for each
date for each name in a Word document?

For instance, in Excel:

Lname Fname 11/19/08 11/20/08 11/21/08
Doe Dick 10 20 92
comments comments comments

Doe Jane 10 18 95
comments comments comments

should be outputted like this in Word:

Doe, Dick
11/19/08
10
comments

11/20/08
20
comments

11/21/08
92
comments


(new page)
Doe, Jane
11/19/08
10
comments

11/20/08
18
comments

11/21/08
95
comments

In Excel, names will start on row 13 and are on every odd row below
13.
There are 2 rows of data for each name.
Dates are in row 12, but the columns the dates start on will vary from
sheet to sheet.
There are 7 sheets named: Period 1, Period 2,...Period 7--data need to
be exported for all 7 sheets. But, the tricky part would be to lump
names that are the same on the different sheets into the same page(s)
in Word.

By the way, this is a gradebook, where 7 sheets are 7 class periods in
a day.
I'm reaching and wishing...Thanks