Hello, folks, I'm getting trouble with a data validation code I've wrote. Let me explain:
1ª) When I run my macro (Crtl + Shift + A) it ask my for a number.
Capturar.JPG
2ª) Once I type any number it creates my a template.
Capturar2.JPG
3ª) From the cell below "Assunto (s)" up to the 100th line there is an data validation linked to the list "Assunto". That's where I'm getting trouble. I need to write some code in such a manner that when I type something on the Assuntos list (The left green box) the validation data is uptaded. Until now, A simple range name with dynamic range could solve this problem although this macro was writted to be used a lot of times in the same worksheet which means i would have to create a lot of range names to be able to uptade each assuntos lists existing.
Capturar3.JPG
I don't if I could make it clear so I record an video to show: /watch?v=jEXb-BRtZI8 (paste after youtube link
Bookmarks