Hey everybody,
Okay this is my problem. I have one data validation box that is dependent on another. Let's say Cell A and Cell B. Now when the value of cell A is changed, the list cell B changes as well, but value of cell B is from the old list and not apart of the new list. I would like for the value of cell B to be cleared out when its list changes. Any ideas?
Krupa
Okay this is my problem. I have one data validation box that is dependent on another. Let's say Cell A and Cell B. Now when the value of cell A is changed, the list cell B changes as well, but value of cell B is from the old list and not apart of the new list. I would like for the value of cell B to be cleared out when its list changes. Any ideas?
Krupa