Macro To Filter Column Based On What I Want To Remain Visible

[Mister_J]

I’ve been looking into finding or creating a macro that can filter a column of categories that continuously grows. I always want to filter the same categories but when new ones are added I have to add the new ones to the list to be filtered out. So can I create a macro that will filter everything except the 3 or 4 categories I use in my department? I found some auto-filter macros but they don't seem to work right and I have spent a while surfing though these forums trying to find something similar but have had no luck. If you need any further info or would like me the clarify please feel free to ask, and any help would be appreciated. Thanks! - Jason

Example: (I only want to see the rows that have electrical and mechanical, regardless of how many other variables are in this column.)

GIS
Electrical
Mechanical
Project Support
Management Directive
And so on…
And so on…

 

[DanteAmor]

Again with pleasure. Thanks for the feedback