Hi I saw many of your videos on youtube and looked on the web for an answer in excel and didn`t find it. I am writing many experts.
The thing is:
1.- I create a validation list A.
2.- In different column B we complete a long list based on the options of list A
3.- Here comes the issue. Someone updates the names in lista A, but the list B dont update.
Example: In list A a word in the list originally was Dog, but then is becomed Dog`s, but the list B dont update with the corrected word. How can we make it work I am writing from Bolivia - South America. We would appreciate your help.
Dan