Hi Everyone,

I’ve had a look around online and can’t seem to find the answer to this.
I’ve created a drop down list from a set of values on a separate worksheet 2 in my workbook.
I’ve made them into a table.
I’ve used the data validation function to turn those values into a list
Have successfully created drop down lists in worksheet 1

However, I find myself needing to alter the values. And I’m wondering if there is a way of excel auto updating that value, once the item has been chosen from the list.
For example, the table has apple as a value.
The drop down list has apple.
I choose apple.
Later, I need “apple” to be “red apples”
I change the value in the table.
But the cells where I have already chosen “apple” do not update to “red apples”
However if I click the arrow to show the drop down options, I can see “red apples” there.

Unfortunately I can’t link the workbook I’m working on.

Thoughts?

Kind regards,

Tom