Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Change data validation original list updates the other lists


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. 



Hi Dan and welcome to the Forum.

Please edit your question to name the tutorial you have followed and use the Add Files... button to attach your Excel file. 
John_Ru (rep: 2867) Jan 11, '22 at 5:20 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login