| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtered values
Hello
How can I export only the filtered values in one tab to a new tab? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtered values
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtered values
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 jc wrote: Hello How can I export only the filtered values in one tab to a new tab? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Count Unique Values but not Filtered or Hidden Values | Excel Worksheet Functions | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| average filtered values | Excel Worksheet Functions | |||
| Sum filtered values only | Excel Discussion (Misc queries) | |||
Linear Mode
