Filter and copy to another worksheet

  • Thread starter Thread starter filter
  • Start date Start date
F

filter

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??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Excel Move or Copy Stopped Working? 0
Macro to copy value in field and insert it into filter 2
excel 2007 filter 3 text values at the same time from the same co. 1
Copying a Filter list to a new worksheet. 1
Excel 2007 - copying filtered data to another workbook 1
Copy/paste data across filtered rows 1
Dificulty in copy and paste when items is filtered in excel 2007 2

Back
Top