Hi,

I have a workbook that has a named range for expenses. These expenses are linked to data validation lists throughout my workbook. The named range is composed of "Salaries," "Machinery," and "Taxes." I recently had an employee type the word "Salary" into the named range. The problem is, throughout my workbook, the many data validation lists had already been dropped down to "Salaries" and all cells indexing off of them output errors as the values since they should now have been indexing off the word "Salary." Is there a way to automatically update the data validation list values that had previously been selected any time someone makes the mistake of changing a word in the named range? I assume there is a workbook_change event that could be used?

If I wasn't clear enough with this, let's say Sheet2, cell B2, has a data validation drop down list referencing the named range. When the word "Salaries" is changed to "Salary" in the named range, I'd like cell B2 to automatically update to "Salary," or whatever string replaces the original value in the named range.

Any help is beyond appreciated.