Simply copy your visible range and paste. Else, use AdvancedFilter and
launch it while on your destination sheet.
http://www.ozgrid.com/Excel/advanced-filter.htm



--
Regards
Dave Hawley
www.ozgrid.com
"jc" wrote in message
...
Hello
How can I export only the filtered values in one tab to a new tab?