See the example I gave you - it does exactly what you need it to. On top of
that you can use a dynamic range as the soiurce that will automatically pick
up new entries as you enter them. All you will have to do is right click
on the table and select refresh. If you really really needed it to update
automatically without so much as having to refersh the table then that can
be done quite easily with code, but i would have thought overkill in this
instance - but it can be done quite easily.

Dynamic source range:-
http://www.contextures.com/xlPivot01.html

An Excellent intro to Pivot tables
http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip