khalid79m
01-21-2010, 11:28 AM
Example
I have 4 Different headers , Fruit , Cars, Shapes, Money
underneath these headers I have different types of each header, for example fruit will have apples, oranges etc.
These lists are dynamic so the when I add an item the named range for Fruit_List exapands and if I remove one it decreases.
I have then set up a cell with drop down using data validation and using the indirect function I have tried use the value in d16&"_List" to utilise the drop down but i keep getting an error.
I have attached a workbook ... please help :banghead:
I have 4 Different headers , Fruit , Cars, Shapes, Money
underneath these headers I have different types of each header, for example fruit will have apples, oranges etc.
These lists are dynamic so the when I add an item the named range for Fruit_List exapands and if I remove one it decreases.
I have then set up a cell with drop down using data validation and using the indirect function I have tried use the value in d16&"_List" to utilise the drop down but i keep getting an error.
I have attached a workbook ... please help :banghead: