Hi Moutassem

This example use AutoFilter and copy to a new sheet

Activate AutoFilter:
Select a cell in your data table and use DataFilterAutoFilter 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 F5SpecialCurrent regionOK
3) Ctrl c or EditCopy
4) InsertWorksheet
5) Ctrl v or EditPaste
6) Select the sheet with the filter ( Sheet("Yoursheet") )
7) Press Esc
8) Press Alt d f f or DataFilterAutoFilter to turn off AutoFilter


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Moutassem" wrote in message ...
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