Conditional Dropdown List

[rguliuzza]

Hi there,

Here is the issue.

Cell A1 = dropdown list - number of choices from 1 to 6

Cell A2 = Choice 1 dropdown list
Cell A3 = Choice 2 dropdown list
Cell A4 = Choice 3 dropdown list
Cell A5 = Choice 4 dropdown list
Cell A6 = Choice 5 dropdown list
Cell A7 = Choice 6 dropdown list

My dilemma, and I am sure it is a simple solution, is when a choice is less than 6, I don't want the dropdown list active for those additional cells. For instance, if cell A1 = 4, then I don't want Cell A6 and Cell A7 dropdown lists active.

Any assistance is greatly appreciate.

Thank you,
Rick