LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter and copy to combo box saman110 via OfficeKB.com Excel Discussion (Misc queries) 1 September 17th 07 02:42 AM
Copy filter Information kmodrall Excel Discussion (Misc queries) 2 August 8th 07 04:22 PM
Copy Paste in Filter Gops Setting up and Configuration of Excel 1 July 16th 07 12:44 PM
A formula to filter data and copy it from one worksheet to another GeneR Excel Worksheet Functions 6 October 25th 06 03:32 AM
How can i copy and paste data when there is a filter in the worksheet.... dalipsinghbisht Excel Discussion (Misc queries) 5 March 18th 06 12:38 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"