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!

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!

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top