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,
Aaron van der Heijden
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.
8 Replies
- Instead of typing into the source window, type your options in a list in the workbook, then select the cells as the source.
- 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?
