Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter and copy to another worksheet
I have a worksheet that I need to divide out in different tabs. Instead of
manually copying and pasting each type, I would like to filter the criteria and copy it to each tab. Filters can only be copied to the active sheet. Is there any way around this, or any other solution?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter and copy to another worksheet
Hi filter
See this page for a code solution http://www.rondebruin.nl/copy5.htm See also this add-in (code is faster for what you want) http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "filter" wrote in message ... I have a worksheet that I need to divide out in different tabs. Instead of manually copying and pasting each type, I would like to filter the criteria and copy it to each tab. Filters can only be copied to the active sheet. Is there any way around this, or any other solution?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter and copy to combo box | Excel Discussion (Misc queries) | |||
Copy filter Information | Excel Discussion (Misc queries) | |||
Copy Paste in Filter | Setting up and Configuration of Excel | |||
A formula to filter data and copy it from one worksheet to another | Excel Worksheet Functions | |||
How can i copy and paste data when there is a filter in the worksheet.... | Excel Discussion (Misc queries) |