Spreadsheet help.
 

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.

Spreadsheet help.
 

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

On Fri, 31 Jul 2009 10:20:01 -0700, Wmoody
wrote:

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.