Hi, I am in need of dire assistance. I have an excel sheet that has 5 columns and dynamic range of row.
Column A has Error Messages that can either start with ED*, O14*, and HL*.
Columns to be hidden dependent on Column A value is below

  • ED*- only column B and C hidden
    O14*- only column B, C, D hidden
    HL*- only column C and E hidden

However, I don't want the columns to be hidden just to a that particular cell in Column A, but to that row of that cell.
I attached a sample excel file.
sample.xlsx