Hello, You can select the Auto filter results only but before copying you must choose the option of Select visible cells only (ALT+;) then chose copy and paste the result wherever you require it.Without using the option of select Visible cells every result will be copies as if there is no auto filter.You can also select the auto filter result using normal cop ,but while pasting you should use paste special and paste vales with or without formatting.If done without formatting you have to format and resort the text in your required format.
Regards, VIJAY KUMAR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
