Hi ArnyVee,

From past experience(and I have made countless number of data capture sheets ), I would consider having two dropdown lists, first dropdown would have all group names, and the second dropdown would have all items that are grouped under the selected group name.

however I would for this use a little bit of VBA for ease, altho im not sure how easy it would be to do with out VBA.

Hope this helps in some way,