group of values with the same

[Steve Wallace]

I have a list in the format

Floor manager; Team manager; Agent; Stat 1;stat 2 ...
FM1; TM1; A1; 1% ; 1%...
FM1; TM1; A2: 1% ; 1% ...
FM1; Tm2; A3; 1% ; 1%
FM1; TM2; A4; 1%; 1%

I need to extract for a specific Tm each agent and their stats
in the format

TM:

Agent 1; STAT1; Stat2
Agent 2; Stat1; Stat2

With each TM having his own sheet. There are randomly sized teams, and no
consistant number of teams to a ccm.

Can anyone suggest a way to automate extraction?

 

[Tom Ogilvy]

http://www.rondebruin.nl/copy5.htm

has most of what you need.

 

[Tim Marsh]

if i've understood correctly, you could use Pivot Tables for a non-VBA
solution [Data] -> [Pivot Tables...] and arrange the table as you have in
the description. Also, if you put TM in the Page Field, you can
automatically generate separate pages for each TM by choosing [Pivot
Table] -> [Show Pages...] from the pivot table toolbar.

hth,

tim