Windows browser Parent/Child structure

[ERK]

Is it possible to setup a cell structure such that when I click on it a "Windows browser Parent/Child structure" opens and closes?
Similar to the folders with the "-" and "+" signs of the browser? His means that an entire set of rows appear or disappear by clicking on the cell?
If so, could you please point me in the right direction so I can do this.

Thanks
Erich

 

[Gord Dibben]

Maybe Data>Group and Outline>Group will work for you.

See help on that subject for more info.

Or possibly set up a PivotTable for grouping.

Or use Data>Filter>Autofilter to show rows with your criterion.

As far as clicking on a cell to achieve your ends, you would need event code to
look after that.


Gord Dibben MS Excel MVP

 

[ERK]

Thanks a lot, took a quick look and it has the potential of doing what I
want.
I will look at the help.

Thanks,
Erich