Dear VBA experts:
I'm trying to create a macro but failing miserably, if anyone could help please.
Depending upon text (validation list) contained under Heading 2 (cell F3, F4, F5 and so on...), I would like Group or groups of columns (Columns H to AD) to expand to match the last entry in Column F (cell F3, F4, F5 and so on). The expansion needs to be only to Level 2 of groupings and not level 3.
E.g. If there is Apple and Banana in Heading 2 (cell F3), then I want columns H to J + columns N-P to Expand to level 2. The other colums should remain at Level 1 (completely collapsed). Then same repeats depending on the last entry cell in column F.
Is this achievable?
Appreciate feedback.
Thanks
Bookmarks