ExcelBanter - auto group row and/or rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - auto group row and/or rows (https://www.excelbanter.com/excel-discussion-misc-queries/196230-auto-group-row-rows.html)

bduncan

auto group row and/or rows

I would like to group the cells that are filled in column A automatically.
If A2 is filled I would like it to be grouped. I also need to group cells
A10-A15 together is they are filled. In this example I would have 2
different groupings of rows; A2 and A10-A15.

All times are GMT +1. The time now is 02:13 PM.