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 |
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 |
All times are GMT +1. The time now is 12:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com