Hello Experts,
I need 2 dropdowns in my excel sheet.
First dropdown will have Yes and No values.
The 2nd dropdown should be populated if the first dropdown is selected as Yes or else the 2nd dropdown should not be populated.
The 2nd dropdown will have 4 values A,B,C and D.
Now when 1st dropdown is selected with Yes this populates the 2nd dropdown with A,B,C or D values.
Now when A,B,C,D is selected in the 2nd dropdown the value must be fetch from the 4 cells of A,B,C,D which are in another sheet in the same excel file into Year 1,Year 2,Year 3. If No value is selected in the first dropdown then the 2nd dropdown should be disabled and Year 1,Year 2,Year 3 columns should be 0
Untitled.png
Bookmarks