Help with Dependent Dropdowns

1) On the HIDDEN sheet, move the list up so that the title is in B1 and the choices start in B2.

2) Change the definition of the "Materials" named range to the following dynamic formula, this will expand and contract by itself as you add/remove from the column B on the HIDDEN sheet:

=OFFSET(HIDDEN!$B$2, , , COUNTA(HIDDEN!$B:$B)-1, )

2) On the Inventory List sheet, click on B5, then open the Name Wizard and click NEW... create a named range called:

MaterialAnchor that RefersTo: =InventoryTable[[#Headers],[MATERIAL TYPE]] (that should be automatic)

NOTE: This should needs to stay organized the way it is, with all like items from column B grouped together.

3) On the Inventory Pick List sheet, put in the following dynamic DV formula in cell D4, then copy down:

Allow: List
Source: =OFFSET(MaterialAnchor, MATCH($C4, 'Inventory List'!$B:$B, 0)-5, 1, COUNTIF('Inventory List'!$B:$B, C$4), )

4) Formula in E4:

=IFERROR(VLOOKUP([@[INVENTORY CODE]], InventoryTable[[INVENTORY CODE]:[DESCRIPTION]], 2, FALSE),"")

5) Formula in G4:

=IFERROR(VLOOKUP([@[INVENTORY CODE]], InventoryTable[[INVENTORY CODE]:[QTY]], 5, FALSE),"")