Automatic Dropdown list selection, is it possible?

[Waves852]

I set up a worksheet to respond to user input. Its calculating how many times a certain word comes up based on the number of times its selected from a collumn of dropdown boxes.
From there I would like another dropdown list to automatically respond by " reading" the quantity in the output field and making the appropriate selection.
The trick is I need the user to be able to alter the automatic entry without affecting any formulas anywhere in the sheet by selecting the last dropdown box and selecting a different option should it be required.

For example.
Field 1 will calculate how many times the word "bathroom" appears in a certain column. (The result could be 1 or 2 bathrooms per that house for instance.)
Then based on that result I would like the workbook to auto populate the next drop down list ( Lets call this Field 2 ) with the appropriate number from that list, allocating say 1 bath to each bathroom.
If however the user needs 1 bathroom to have a bath and the other to have only a shower I need the worksheet to allow the user to select a different quantity from the same drop down list ( Field 2 )to ultimately achieve the collect result on the output page.
Obviously I need the formula for automatic selection to remain in place even if the user decides to change the result.

Anyone?
Ps. I'm using Excell 2010 fro the ultimate application of the workbook but i'm designing the entire thing in Open Office from home. Therefore posting an example worksheet is a bit difficult.

[Richard Buttrey]

Hi,

Sounds like you need dependent drop down lists and if so I can do no better than point you to Debra's web site at:
http://blog.contextures.com/archives...ists-in-excel/

[Waves852]

Thanks for the reply, its appreciated. I'll check out the link ...
Waves