I am having trouble finding a forum that answers my questions. I am looking to hide columns based off a selection from a drop down combo box assigned to cell D1. I tried using helper rows that show what columns have that title selected in the drop down, but am unsure how to assign a code to hide columns that do not contain that text.
For example:
There are a list of columns with the titles Cust 1, Cust 1, Cust 2, Cust 3, Cust 4, Cust 4, Cust 3. Some of these columns have the same name, but not necessarily next to one another. I have recorded macros to hide the columns based on the selection, but I would be unable to add any columns in between.
There is also the issue of needing to select more than one option at times.
Essentially I need a code to hide the columns that do not contain a certain text in its header.
Bookmarks