Forum Discussion
Macro Buttons
First of all, get rid of the merged cells in your header row (use Center Across Selection in stead) and put the headers directly above the data range (i.e. no blank row in between). Then, put filter buttons on the header.
Next, get rid of all the individual conditional formatting rules that colour most of the cells grey. You can replace it by one single rule like:
=$I12="x" and apply it to the entire data range.
Now you are all set to use the "filter by color" feature. In the attached file I have set the filter in the Description column to view only rows with "No fill", thus hiding the grey ones. But you could also filter out all the rows with "x" in the Closed column. The "Action by" column was filtered to show only orange cells. These are just examples of what you can do with a few clicks. No need for complicated VBA code. Your users could learn to do that, I believe. But, if they insist on buttons, you could carefully record every thinkable (un)filter action and add one to just "clear all filters" (i.e. revert).