• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

autofilter buttons

ahhhmed

Member
Hi all,

I have a worksheet that have about 5000 entries. These have to be filtered according to different criteria. Now, I need to have a cover page with buttons. Each button is named after one of the filtering criteria. When this button is clicked, filter is applied and the result is shown in the main worksheet. I hope my explanation is clear and that you can help me do this properly. Thanks for your help.
 
Hi, ahhhmed!

Which Excel version are you using? If 2010 perhaps you could build a pivot table with slicers.

Regards!
 
Back
Top