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??