Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy only filtered cells to another table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy only filtered cells to another table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
Populating a table with filtered result of another table | Excel Discussion (Misc queries) | |||
How to copy a filtered range ? | Excel Discussion (Misc queries) | |||
Copy filtered data | Excel Discussion (Misc queries) | |||
Copy on filtered list | Excel Worksheet Functions |