Dear sir,this is my first post to your distinct forum hopping i reach
the ultimate solution because i have sent many messages to different
forums with no replies, i have a workbook with main sheet and about (10)
agents sheets , the main has columns like( date,inv.no,agent name,code
no.,quan.,price,cost,total amount ) ,i enter the data in these columns
daily,what i want from your goodself ( the way can i use to transfer
these data to the agents sheets which contain all above except (agent
column) automatically by ( formula or code) ,i am using excel 2003 and
enclosed herewith an example.
Thanks in advance.


+-------------------------------------------------------------------+
|Filename: sheets2.zip |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=81|
+-------------------------------------------------------------------+

--
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=67250