Ann,
as we seem to be stuck ( it's all probably possible in VBA but I'm no
good at that) maybe we could use an alternative to Pivot Tables.
Would this be acceptable ? ( no "dynamics" of course)
Do you have a list of the sales people?


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94099