• 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.

Auto Filter

S

Shay A

Member
Hello,
I am looking for a code that will filter my data set by clicking. Let's say I have a field called "Year" and I wish to see inly the records of the year of 2016. How do I trigger that filter simply by clicking any record in my data set that meets my criterion? (I mean to click in whatevet row but in the column that contains the years- 2014, 2015, 2016 etc.

Thanks!
 
Thank you both!
I am looking for a VBA solution since at my job place, we use Ofiice 2007- No slicers :/
It is a great feature obviously!
 
I would revert to using a data Validation Dropdown
So you can select a Year using the Data Validation dropdown
then use that to control your extraction range

Can you post a sample file for a more targeted response
 
You must log in or register to reply here.
Back
Top