Master Filter Sheet to Filter All Sheets

This is excellent! You're great man!

How can I get the "Clear All Filters" button to clear out the criteria but not the filters completly?

Originally Posted by nguyeda

How can I get the "Clear All Filters" button to clear out the criteria but not the filters completly?

Did you get this OK? If not, here would be change to make: In the "Sub AutoFilter_AllSheets" macro change

If Len(Crit1) = 0 Then .ListObjects(1).Range.AutoFilter

to the following ...

If Len(Crit1) = 0 Then .ListObjects(1).Range.AutoFilter Field:=1, Criteria1:=Null

Yup, that's exactly what I figured out just a moment ago. Thanks for your help!