Only display list in a cell based on selection in a different list, otherwise default

Start by removing all the data validation drop down lists in column D of all the Order Sheets. I am assuming that the drop down lists in column B of the Order Sheets contain the names of all the products exactly as written in column A of the Item List sheet. Then do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, double click "ThisWorkbook". An empty code window will open up. Copy/paste the macro below into this empty window and then close the window to return to your sheets. In any of the Order sheets, select a product in Column B.

Please Login or Register  to view this content.

I'm not sure what you mean when you say:

column D is blank when only the box is available to order

I thought you wanted the word "Box" as the default in column D when an item is available only in a box according to

How can I make the unit type default to 'Box' if only a box can be ordered

I didn't see the option 'Package' on the Item List. Please clarify in detail using a few examples from your data and referring to specific cells and worksheets. Attach an updated file if necessary.

You are very welcome.