Hi

For your first table
Drag Teacher, Then Date, then Child to the Row area
Drag Sequence then Activity to the column Area
Drag Count of Date to the Data area.

Double click on any fields as necessary, and set Subtotal to None.

For Table 2
Drag Activity then Child to Row area
Drag Date to Column area
Drag Count of Child to Data area

Again, disable Subtotalling as appropriate.
From the PT wizard, choose Table Options and switch off Grand Total for
Rows and Grand Total for Columns

You won't get exactly as you want, but you will a series of "1's" in the
matrix against each of the appropriate headings.
--
Regards

Roger Govier


"C.B." wrote in message
oups.com...
I am trying to maintain a single list with:

AdultName Sequence Date Activity ChildName
---------------------------------------------------------
Teacher1 1 9/1 PickUp C1
Teacher1 1 9/3 Teach C2
Teacher1 1 9/5 DropOff C1
Teacher1 2 9/4 PickUp C3
Teacher1 2 9/9 DropOff C3
Teacher2 1 9/2 PickUp C2
Teacher2 1 9/3 Teach C1
Teacher2 1 9/6 DropOff C2
Teacher2 2 9/7 Teach C3
etc

And generate BOTH of the following:

Schedule 1, Sequential activity list by teacher

Seq 1 Seq 2
PickUp Teach Drop Pickup Teach Drop
------ ----- ---- ------ ----- ----

Teacher1 9/1 9/3 9/5 9/4 9/9
C1 C2 C1 C3 C3

Teacher2 9/2 9/3 9/6 9/7
C2 C1 C2 C3


and Schedule 2, Same data sliced into a calendar

9/1 9/2 9/3 9/4 9/5 9/6 9/7 9/9
----------------------------------------------------

PickUp C1 C2 C3

Teach C1 C3
C2

DropOff C1 C2 C3


I was doing this by putting "=cell" into the two schedules, but data
is
constantly shifting so it became a maintenance nightmare.

Then I found Pivot Tables. That allowed me to generate exactly what I
want, except it doesn't show me the details... it only shows me a
function such as "count". Then, when I click on the count, it shows
the
actual detail of what was counted.

So, I am hoping I can get some help/pointers here. Is it possible to
have PivotTable display the details of the data instead of a count of
the data? Or, if that is just the wrong tool, any other suggestions
that can help me do this in Excel?

I am a somewhat new user to excel, and new to groups, so I appreciate
any pointers if there is a better way I should be searching for this
answer.

Thanks