Hi All,

I'm having an issue with this code. Sometimes it runs and sometimes it decides to not respond. I'm currently running the code from a master workbook that each of these filtered reports will be carried over into. I have about 10 files that are sent as reports every week and would like to apply an autofilter to them. I will need to filter different rows and different sheets for each excel file, thus I cannot simply loop through all of them. When the code works I try adding another file to the folder and more code to autofilter that file, but that's when the macro no longer works. Am I trying to loop through too many if/elseif statements? Any help would be much appreciated.
Please Login or Register  to view this content.
Also, I would like to request some help with the use of wild cards. For example, I have a report that contains numbers that change with each report, but the name of the file also contains "Quarter". Would it be possible to just look for "Quarter" and open the file that matches?

Thank you. I appreciate the time and help!