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?