Help with Dependent Lists

[toneill]

I am having a heck of a time trying to create dependent lists. I am using the named field for the first list box, then using the =INDIRECT(SUBSTITUTE($B5," ","_")) for the second one. It works fine, however, I need a way to have a second column using the same named field, but referencing a different sheet of data.

I am open for suggestion on how to accomplish this. I have tried to combine the two fields into one column, but I have had no success.

I have attached a sheet to help explain what I need. Any assistance woe greatly appreciated
appricated

[DBY]

Hello
One way would be to name your 'MoreData' lists, for example: More_North; More_South etc. Then in column D on the 'Dynamic Lists' sheet in the Data Validation List option, use the formula:

Please Login or Register  to view this content.

Hope this helps.
DBY