Dear sir,with best regards, i have in attached file a scheduale contains
some data like(invoice no.,date,amount, agent) ,i ask you kindly to help
me to transfer these data to (agents scheduales ) as mentioned in the
attached bit from my workbook ,i am using excel 2003 and optained a
(pivot table)solution but i need (formulas or code ) one .
Thanks in advance.


--
tofimoon4
------------------------------------------------------------------------
tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86766