View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
egun egun is offline
external usenet poster
 
Posts: 88
Default Tree organization in excel

Have you thought about using the outlining feature of Excel? It lets you
group your information on different levels and automatically provides the
"+"/"-" buttons you're looking for. Look in the "Data" menu, under "Group
and Outline". Also check out the help topics on the subject. Seems a
perfect way to list all the sub-components of a part under the main part
heading. And since you can have many outline levels, you can break
sub-components down into their parts, etc.

Eric

"Francisco" wrote:

Hello, i have a project to do and i need to filter the data just like windows
explorer does. I mean i want to have a plus sign next to a cell that when i
click on it infromation will pop down. Basically i have different assemblies
and each assemby has different componets so i want to be able to have a
configuration just like windows explorer.

Thanks, i would appreciate the help this project is important.
--
Francisco Kuljevan
Engineering Intern