Data Validation List selection to match change in source

Good-day everyone!

I'm seeking some general ideas/tips for handling the following:

I have two sheets. "Main" and "Data"

On the "Main" sheet I have a table. The table contains a column that has "Data Validation List" cells. The items in the Data Validation Lists are populated by a list located on the "Data" sheet.
When entering records the user selects items from the Data Validation List cells. The user can only select an item from the list or choose to leave the cell blank.

What I would like to have happen...
When the user makes a change to an item on the "Data" sheet, I would like all the corresponding items on the "Main" sheet to change to the new value as well.

E.g.
If on the "Data" sheet, "apples" was changes to "green apples" then all the "apples" entries in the table on the "Main" sheet will automatically changes to "green apples". The other items (bananas) remain unchanged.

I suspect that this would require VBA? Any suggestions how one would go about achieving this?

Plenty thank-you's for your time.

Originally Posted by morse7

I suspect that this would require VBA?

OK, I believe VBA is required for this case. Create a worksheet change event to trigger changes in the column containing the data validation list in the Main sheet.
Then, navigate to the Data sheet to find cells with old values and update them with new values.
Specifically, you should attach a sample sheet to demonstrate the process.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.