Hi everyone. I have two tables, ENTRY and DATABASE. Both have identical columns with the same data: Category and Item. The DATABASE table is populated with hundreds of lines of data like:


CATEGORY ITEM
RED Tom
RED Jim
WHITE Alice
RED Cindy
BLUE Nancy
RED Allan
BLUE Brian
BLUE Bill
RED Tina
So on and so forth...


The ENTRY Table starts blank. I have a drop down list on the CATEGORY column to select uniquely the categories (separate named range). I want a drop down list on each row for the ITEM field, so it will filter only those items that match the previously selected category. Any thoughts? I can't use VBA or macros...