Forum Discussion
Solved
Expand amount of characters for source in data validation
Hello, I am working in excel and I am making a dropdown list with data validation. De amount of characters in the source window is too low. Is there a way to increase this? Greetings, Aar...
AaronvdHeijden Use Named Ranges and INDIRECT. I have attached a quick-and-dirty example demonstrating this. You would have to restructure your listings a bit, but it will work beautifully.
Note that Named ranges only accept normal characters, numbers and underscores and they NOT start with a number. Every sub-option will have to have it's own Named Range.
Could you provide a specific example please
Thank you for you reply.
Example:
Column Type needs to look at value in colomn Groeptype and based on this value fill the dropdownlist.
I put down the source as below:
- I'm trying to understand your requirement but I'm still lost. Can you post the file?
Here is the file.
