filtered values

[jc]

Hello
How can I export only the filtered values in one tab to a new tab?

 

[ozgrid.com]

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

 

[Dave Peterson]

Depending on the version of excel, the way you select the range to copy, you may
find that the hidden rows get pasted as well.

So make sure you select just the range you want to copy
Hit F5 (edit|Goto in xl2003 menus), Special|visible cells only
Go to the other worksheet
Select the cell to paste
Edit|Paste special|paste values