Hi,

I'm using Excel 2007 and constantly working with lists with auto-filter applied. However, a lot of my work involves:

-Selecting the drop-down arrow to display the filtered entries
-Remove the tick from a previously filtered data
-Add the tick to the next entry and then filter the data

I'm doing the above actions with the mouse but since the filtered list has more than a 100 entries, I'm looking for a shortcut or macro to automate the above process. Can anyone please help me out?