Autofilter on Multipleworksheets in Workbook

Morning,

I have a workbook that contains 40+ worksheets, I am looking to apply an autofilter on 20 of the worksheets (so I can then select and copy the filtered data to a new workbook),

The 20 Worksheets all have the same column headers in Row 6, and a date in column A , so I want to apply an auto filter on last weeks info from row 6 column a...

I have had a bash at doing this... and I can sort fo get it it to run on one worksheet, by recoridng the macro etc, but when I try to build in the If statement for excluding the WS that I dont want the filter to run on, it fails miserably... the code doesn't bug out... just doesn't do any filtering!

Please Login or Register  to view this content.

If anyone wants to throw in some code for selecting the range and firing it into another workbook that would be appreciated... not got round to that bit yet.... ;-)

Anyone got any ideas for getting this to work?

Thanks