This should be fairly easy for anyone with even a little bit of VBA experience.
I've provided a hard coded example of what I want done, but need it to be more flexible.
If you click on the green column that says "Name 1" it hides all of the columns except for the others that say "Name 1". I want to do this automatically instead of using hard-coded ranges.
So I want to be able to give it a range and it reads these names into some sort of listbox and then you can check the names that you want to be shown.. all other columns in the "green, yellow, and gray" sections will be hidden.