Windows browser Parent/Child structure

  • Thread starter Thread starter ERK
  • Start date Start date
E

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
 
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
 
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
 
Back
Top