Dynamic Named Range issue with Data Validation

[bamaisgreat]

I have a very similar problem in 2010.
I had just regular named ranges and changed them all to Dynamic as a result my data valadation does not work.
All i have in the Source: box is =INDIRECT (I28)
Could someone help me with this. Thanks



Moderator's note: Please read the Forum Rules.

This post was moved to a thread of it's own since your query in someone else's thread is against the rules. Thanks for taking the time.

[JBeaucaire]

Check out this tutorial on how to use dynamic named ranges for your source lists, but use OFFSET() formulas in your Data Validation lists to keep from having the INDIRECT() problem.

DYNAMIC CASCADING DROP DOWNS THAT WORK, no INDIRECT PROBLEM

http://www.excelforum.com/excel-tips...t-problem.html



For more specific assistance, you will need to click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

[bamaisgreat]

I appreciate your help, this is the first time I have used the forumn.

[Johncoltrane]

Hey JBeaucaire,

Thank you for providing information of "Dynamic Named Range". You have made some really helpful statements and I appreciate the time you’ve taken within your producing.

[bamaisgreat]

Here is another helpful link with a attached Example Workbook.

http://www.contextures.com/xlDataVal02.html#Dynamic
The Forumn is Great
Thanks you all

[JBeaucaire]

I have marked this thread solved for you.

In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.