data validation list based on other data validation list

[Manu007]

Hi Everyone,

I am trying to create a different data validation list in several coloumns based on a data validation list in a cell.
Please suggets me the possible solution. i dont think indirect function is helpful here.

Thanks Again,
Manu

 

[VoG]

Maybe this http://www.contextures.com/xlDataVal02.html