Spreadsheet help.

[Wmoody]

OK, so I'm not sure what it is I'm trying to do, but I'll give you my
scenario and I hope someone can help me! I need to be able to input info
about a real estate property. So, if it has a porch then it'll let me pick
windows, wall. Type of flooring. etc.. But if it says "no" to porch then the
options do not appear.

 

[Gord Dibben]

See Debra Dalglesih's site for creating dependent lists.

http://www.contextures.on.ca/xlDataVal02.html

In your case a dropdown with "porch" and "no porch" will give you two
distinct lists to select from.


Gord Dibben MS Excel MVP