Dear Mr.Don ,with my appreciation,my e.mail is
Dear Mr.donaldb36 ,thanks for your solution ,but my need is to transfer
data not sortig ,i have many agents sheets and main one as mentioned in
above example,hopping you have seen it.
Thanks to all.


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