See that's my problem; I can hide the columns based on cell value which is fine, but I also need the columns to be hidden to the row of that cell as well. For instance, A2 has ED*; A2 will have only column B and C hidden, but the column B and C hidden would be visible in D2 and E2 and I want it hidden. The hidden of columns should apply to the entire row dependent on cell value in column A.
Bookmarks