Hi All,

I am trying to expand a certain grouping when an "X" is selected in a drop down menu in the row above where that given grouping begins. I have tried recording a macro but it does not seem to record when I click to expand a grouping and I am new to using any sort of VBA in excel.

For example if an X is placed in A25 I want the grouping that ranges from rows 26-33 to expand.

Thanks!