Autofilter Problems

I'm trying to set up an autofilter macro that will filter out results from multiple sheets using criteria that is set up on an independant worksheet at the begining of the workbook and return the information to another sheet. I'm using the following code but I can't seem to get it to work. Any help would be appreciated

Please Login or Register  to view this content.

Originally Posted by frog_monkey

I'm trying to set up an autofilter macro that will filter out results from multiple sheets using criteria that is set up on an independant worksheet at the begining of the workbook and return the information to another sheet. I'm using the following code but I can't seem to get it to work. Any help would be appreciated

You should use ADVANDE FILTER and choose copy to another location instead of using auto filter
First, you should record a macro to do that, then edit and customize this macro, and incorporate it into your application
.