CodeRedR51
Premium
- 55,442
- United States
Ok, so I am doing this project at work and need to know if this is possible. Basically what I am looking for, is to make a drop down box based off of the "Make" column, and when you select an option in that dropdown it filters to show you only the cars associated with that particular make.
Example: If I select BMW 1-Series F20 from the drop-down (circled in red), it hides everything but the rows highlighted in green from the photo below. I can't seem to find anything about how to do it on the net because if I include the word "filter" in the search it just talks about the filter function in Excel 2007 and that's not what I need.
Anyone?
Example: If I select BMW 1-Series F20 from the drop-down (circled in red), it hides everything but the rows highlighted in green from the photo below. I can't seem to find anything about how to do it on the net because if I include the word "filter" in the search it just talks about the filter function in Excel 2007 and that's not what I need.
Anyone?
