Reply to thread

Message: [QUOTE="LiAD, post: 3803764"] 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 [/QUOTE]