Macro to group rows and columns based upon each Row/column for multiple sheets in workbook

Vbalearner85

New Member
Joined
Jun 9, 2019
Messages
11
Hi VBA champs..need help in designing "Macro to group rows and columns based upon each Row/column value in corresponding cell value for multiple sheets in workbook "

1. Each row should group independently for particular cell value say(0) in column "B" of same worksheet and ungroup for "1" automatically. (Row 2 should group/ungroup based upon value in cell "B2" ..Row 3 for cell "B3"and so on
2.Each column should group for particular cell value say(0) in row "B" of same worksheet and ungroup for value "1" automatically. (Column C should group/ungroup based upon value in cell "C2", column D for value in cell "D2" and so on
3, Need 1 summary sheet...which should have option for which all sheets to apply grouping conditions for above. (suppose need to exclude some sheets for above rules)

Thanks in Advance
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,099,755
Messages
5,470,585
Members
406,711
Latest member
okyok

This Week's Hot Topics

Top