Hello,

I start with a list of text, a, b, c, d, e, f, g etc that I turn into a
drop down selection list using the data validation. The user then fills in
the sheet with whatever other fields they need.

However supposing I need to change d to z on the input list I am stuck with
data based on the old list. Is there a way that when I update the inputs I
can get excel to automatically go back through the filled in data and replace
all d with z in the table?

Thanks