Forum Discussion
Expand amount of characters for source in data validation
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.
Here is the file.
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.
- I will try this and it seems that it will work. Thank you very much
AaronvdHeijden Graag gedaan! Kom gerust terug als je nog meer vragen hebt.