masternitr
New Member
Hi,
For a customer survey, I have 11 parameters which is to be rated from 1 to 11. Eleven dropdowns has to be creted. The employer requirement is such that all the parameters has to be showed in a dropdown. The user will select one choice from the dropdown and then submit it using a button. Then in the adjacent column, the dropdown will have all the options except the one the user has selected in the first dropdown. The user selects one and submits it. Then, in the next column, the dropdown should have 9 options and so on.
I am clueless about how to proceed. Please help.
The dropdown has to be created using data validation.
For a customer survey, I have 11 parameters which is to be rated from 1 to 11. Eleven dropdowns has to be creted. The employer requirement is such that all the parameters has to be showed in a dropdown. The user will select one choice from the dropdown and then submit it using a button. Then in the adjacent column, the dropdown will have all the options except the one the user has selected in the first dropdown. The user selects one and submits it. Then, in the next column, the dropdown should have 9 options and so on.
I am clueless about how to proceed. Please help.
The dropdown has to be created using data validation.