Just as the title suggests. I've been trying to reverse engineer the Macro from this this site: http://www.ashishmathur.com/automati...-list-changes/
If you refer to the downloadable 'workbook'

Overall Question: After creating a validation list in a cell, one may enter one any value in that cell from the cell drop down. Once a selection is made in the cell drop down, a change in existing source entries (say a spelling change) of the validation list will not cause the cell entry to be changed (although the cell drop down values change).

I am using Microsoft Excel 2016 (Windows computer)

**I'd like to ALSO apply this when the source list and the data validation lists are in DIFFERENT worksheet