View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Subcategories in Drop Down List

pspork submitted this idea :
Is it possible to get a drop down list that is pulled from two different
lists?
Such as:

Roof
-Demo
-Rebuild
Floor
-Demo
-Rebuild
Structure
-Demo
-Add new beams
-Rebuild

and etc.

I know you can do it by making one list dependent on the other, but my
spreadsheet does not have room due to the inclusion of other columns.
Any help is greatly appreciated!


Why can't you store the lists on another sheet?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion