I have a production schedule that has dates accross the top and models
down the side. I want to be able to summarize the products that need to
be build each day instead of showing all the data.

Example Data Source

11/1/2005 11/2/2005 11/3/2005 11/4/2005 11/5/2005 11/6/2005
FF100 25 50 180 0 0 0
FF101 0 100 0 0 0 0
FF102 25 0 0 75 150 0
FF103 0 0 0 0 0 150
FF104 0 0 0 0 0 0
FF105 25 100 0 0 0 0
FF106 0 0 0 0 0 0
FF107 50 25 0 75 25 0
FF108 25 0 0 0 0 0

Expected Summary


FF100 11/1/2005 25
FF102 11/1/2005 25
FF105 11/1/2005 25
FF107 11/1/2005 50
FF108 11/1/2005 25
FF100 11/2/2005 50
FF101 11/2/2005 100
FF105 11/2/2005 100
FF107 11/2/2005 25
FF100 11/3/2005 180
FF102 11/4/2005 75
FF107 11/4/2005 75
FF102 11/5/2005 150
FF107 11/5/2005 25

I have tried various functions but can not get it to work. Anyone have
a suggestion? Thanks in advance!