I have 5 worksheets in an excel document. I need to a filter column and select 30 items in a list of 100. I need to do this on all worksheets. Is there anyway to copy and paste the filter data for 1 column to another worksheet? It would be so helpful.