how to copy only filtered cells to another table

M

Moutassem

i did a filter to a table and i want to copy the results and only the
resulting cells to another table, but it does not work with me, i don t know
why? can some one help me regarding this issue?
Thanx
 
R

Ron de Bruin

Hi Moutassem

This example use AutoFilter and copy to a new sheet

Activate AutoFilter:
Select a cell in your data table and use Data>Filter>AutoFilter to activate AutoFilter.
Tip: Shortcut for the English version is Alt d f f

In each header cell a dropdown will appear next to your field name.
Click on the dropdown in the ? field and choose ?

Copy the filter result
1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Ctrl c or Edit>Copy
4) Insert>Worksheet
5) Ctrl v or Edit>Paste
6) Select the sheet with the filter ( Sheet("Yoursheet") )
7) Press Esc
8) Press Alt d f f or Data>Filter>AutoFilter to turn off AutoFilter
 
Top