• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Dropdown which should continuously reduce its size

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.
 
Something like this might help. (hide previously used items)

http://www.contextures.com/xlDataVal03.html
 
Back
Top