Hi guys, I'm a novice excel user, but have the following
query in Excel 2000.

I have a spreadsheet that contains numerous rows and on
each row I have applied an auto filter.

I have a button that I want to attach a macro that will
automatically apply a filter to the data. Does anyone
have any ideas?

Many thanks.