I apologize for the confusion. I have Name, then type_of_work performed
(phone desk, garden club, speaker, etc) on the rows and months of the year on
the columns. I need to be able to be able to find totals for the
type_of_work by month, monthly totals for all type(s)_of_work by volunteer,
as well as yearly totals. So it's really a 3 dim array (name, type_of_work,
month). I need to keep it in Excel so that it can be maintained by anyone in
the future if I'm not available.
Thank you for your help!

"topola" wrote:

I'm not sure whether I properly understand your question 'cause you
haven't provided any example of how your raw data is organized in the
worksheet. I assume what you need is a simple Pivot Table with two
fields inserted as in a ROW {Names, Type_Of_Volunteer} or adversly
{Type_Of_Volunteer, Names}, one in a COLUMN i.e. Month_Of_Year and in
DATA Sum of Numbers. To see both fields Names and Type_Of_Volunteer
while being on the first field you should use Show Detail from
RightMouseMenu Group and Show Detail.

HTH,
Tomek Polak, http://vba.blog.onet.pl