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?

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

has most of what you need.

--
Regards,
Tom Ogilvy


"Steve Wallace" wrote:

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?

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

"Steve Wallace" <Steve Wallace @discussions.microsoft.com wrote in message
...
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?