Autofilter across Worksheets

[mattalin]

I would like to be to able apply an autofilter across multiple worksheets. My file contains about 20 worksheets that all require the same autofilter. I tried recording a macro but it will only work for the active sheet:

Sub Autofilter_no_zeros()
Selection.AutoFilter
ActiveWindow.LargeScroll ToRight:=1
Selection.AutoFilter Field:=14, Criteria1:="<>0", Operator:=xlAnd
End Sub

Thanks in advance for any help.

 

[santeria]

Just a lateral thought....
This reference is applying a different idea across many sheets...
Hopefully the relevant section/s are self-evident... may be useful

http://www.mrexcel.com/board2/viewtopic.php?t=37441&highlight=autofilter+across+worksheets