sujittalukde
07-08-2008, 05:35 AM
In the attached file, the sheet named Validation contains Data Validation List.
The drop down for cell B1 is dependant on Cell A1.
If in cell A1, Vegetable is selected then the drop down list in cell B1 shows items related to Vegetables only.
If I change the cell A! from Vegetable to NA, the cell B1 keeps the earlier value say Potato ( ie the value that was chosen when the cell A1 = Vegetable).
I want that if the value at cell A1 is changed to NA the value at cell A! should also change to Blank or NA automatically.
How this can be done?
The drop down for cell B1 is dependant on Cell A1.
If in cell A1, Vegetable is selected then the drop down list in cell B1 shows items related to Vegetables only.
If I change the cell A! from Vegetable to NA, the cell B1 keeps the earlier value say Potato ( ie the value that was chosen when the cell A1 = Vegetable).
I want that if the value at cell A1 is changed to NA the value at cell A! should also change to Blank or NA automatically.
How this can be done?