Inserting Totals into Worksheet

[Guest]

I'm hoping you can help...

I have a template listing the names of agents with their position. Using
this list I want insert a total line whenever a position changes.

For instance:

Group of Position 1
Agent 1
Agent 2
Agent 3
Total of Position 1
Group of Position 2
Agent 1
Agent 2

The catch is there are many teams that are available from a drop-down list.
Not all the teams will have the same number of people in each group and not
all groups will be available to the supervisor.

I can get as far as creating drop-down list for the supes. Creating the
agent list assigned to that group as well as their assigned position. But
inserting the Total line proves difficult since it will always be moving.

Any suggestions would be greatly appreciated!
CEverhart

 

[Debra Dalgleish]

Instead of listing all the agents in one columns list each group in a
separate column, with the total at the top.