Been meaning to post earlier but I am geting ready to move back to Australia and things are just a little hectic :-)
Anyway, here is a very basic horizontal filter, saw someone mention they wanted one a while back and thought it might be interesting to make...
Basically a filter hides things, not very hard to...all we need is a list to choose from to decide what shows or not, Data Validation does that for us nicely.
The download link for a sample file with code is here.
Before filtering, push the Set Range button to ensure cells from C2 to the last cell in the used range are included. (There is a comment with instructions in Cell A1)
Make your selections from the cells with validation lists in Column B, then push Set Filter...
What the code does not do at this time is update the Data Validation lists (filter cells in Column B) to show only visible columns after the first selection onwards. Not a big thing but I will look at doing that in the future (when I have time)
See you again soon ;-)