Autopopulate with dropdown menu for selected file only

[adhi yuliartha]

Really needs some help. I have 2 worksheet in excel, first worksheet called "inventory", and second worksheet called "consumption".
The inventory worksheet is the big list of items that we have in store(ex: apple, mango, grape, orange, carrot, banana etc up to 200 items).
In this worksheet, coloumn A is the item name, and coloumn B is the quantity. in some cases, we dont have all the item in the inventory, for example only 50 items that having the quantity (other items is 0)
In the worksheet "consumption", it also have coloumn A with item's name and coloumn B with quantity.
in Consumption worksheet, i want to create a dropdown list in coloumn A, that automatically only populate the items that we have in the inventory worksheet (50 items) (not showing all items (200 ea) in dropdown list)

Thank,

 

[sergioMabres]

This is called data validation with Filtered Data there are a couple of ways of doing this:
1. Using macros shown in http://www.mrexcel.com/forum/excel-...data-validation-list-based-another-entry.html
2. Using matrix formulas like shown in Excel 2007: Data Validation list with filtered data - Stack Overflow

Regards
Sergio