Referencing the attached spreadsheet, when a users filters on column B (Class) I want to hide the columns the are not applicable. Applicable columns are listed on Map sheet by class, X = display and blank = hide.
An alternative would be to hid columns with no data. This should work with a multi-select filter as well.
I don't know much about VBA in excel, so please try to keep it simple.