Drop downs based on selection from other drop downs

[Mississippi Girl]

Hiya! Hope y'all can help me again!!

I have a list of Projects, WBS codes, and BLI codes. I'd like to create a budget planning spreadsheet for multiple project managers to use for their annual planning. Instead of sending out customized templates for each project manager, I'd like to incorporate drop downs that will allow the project managers to select their project, then a WBS based on the project they selected, and finally their BLI codes based on the WBS selections.

Projects have multiple WBS codes, and WBS codes have multiple BLI codes, however WBS codes and BLI codes can have only one Project code. Is there a way I can do this ?

 

[francisp]

Yes it is possible. Check this link : http://www.contextures.com/xldataval02.html

 

[Mississippi Girl]

Thanks! I was able to get this to work. If anyone else runs into this question - the way you name ranges is the key. It can be a bit confusing and if you have a lot of different options availabe in the beginning, you will have a lot of named ranges to follow...