Is there a way to make the data validation dynamic. In other words, if I update the validation list can it auto update the cells that are tied to it? Right now if I update the list the original data does not change, which is causing havoc with the formulas I have tied to it.

Thanks in advance.