| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subcategories in Drop Down List
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Quote:
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're working on would help... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform Listbox subcategories? | Excel Programming | |||
| How do I hide subcategories in Excel? | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
