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