Subcategories in Drop Down List

P

pspork

Is it possible to get a drop down list that is pulled from two differen
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 m
spreadsheet does not have room due to the inclusion of other columns.
Any help is greatly appreciated
 
G

GS

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!
Click to expand...

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
 
S

Spencer101

pspork;1609216 said:
Is it possible to get a drop down list that is pulled from two differen
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 m
spreadsheet does not have room due to the inclusion of other columns.
Any help is greatly appreciated!
Click to expand...

Why not just have the list saying:

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

Perhaps I'm completely missing the point of your query.
Maybe some further information or perhaps an example of the sheet you'r
working on would help..
 
Top