Sample file for this exercise: Auto-AutofilterMacro.xls
"I have a list of stores in one table. I have Problem tickets with associated store numbers in another. I want to be able to press a button to Autofilter by store number and have it cycle through the list i.e.
"So I would push the button and it would filter all problems at store 1. Bush the button again and it would be store 2. Push again and store 3. The list to scroll through is Store List."
Filtering Tricks >