Drop down boxes to choose options with named ranges - a better way?

[RockandGrohl]

Hi guys, I'm looking at improving a quote sheet we use. Essentially what our clients do is put their line items in that they are charging for, and then categorise them within our defined structure which exists in a sheet called "WBS"

If you think the data looks like this in the WBS:

Cost Heading	Cost Group	Asset
Vegetables	Large	Zucchini
Vegetables	Large	Cabbage
Vegetables

 

[RockandGrohl]

Apparently CTRL + ENter just posts the thread. This can be deleted please.