If you take some time to play with the autofilter you will see the
advantages of keeping it together. You can get so much more information from
the data that way. Some would advocate a pivot table.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tofimoon4" wrote in message
...

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