| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
