Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
questionnaire providing list of requirements
I'm trying to create a yes/no questionnaire in excel and need to incorporate
some additional criteria: 1) Questions are broken into categories. If the 1st response to any given category is"no", then all other questions of the same category are greyed out, not displayed, or automatically answered for the respondent. 2) If any answer is "yes", then a separate worksheet lists certain requirements pertaining to the original question. At this time I have IF/THEN statements such as IF B5="yes" then display the contents of <data worksheet However, this leaves large blank areas if a respondent answered "no" for one category but "yes" for the next. 3) The requirements listed should then be formatted for easy printing or exporting. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
questionnaire providing list of requirements
It sounds like you're going to need to use VBA to do what you want. Start
with the Worksheet_Change event. -- HTH, Barb Reinhardt "jammyjamms" wrote: I'm trying to create a yes/no questionnaire in excel and need to incorporate some additional criteria: 1) Questions are broken into categories. If the 1st response to any given category is"no", then all other questions of the same category are greyed out, not displayed, or automatically answered for the respondent. 2) If any answer is "yes", then a separate worksheet lists certain requirements pertaining to the original question. At this time I have IF/THEN statements such as IF B5="yes" then display the contents of <data worksheet However, this leaves large blank areas if a respondent answered "no" for one category but "yes" for the next. 3) The requirements listed should then be formatted for easy printing or exporting. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
questionnaire providing list of requirements
jammyjamms -
I suggest using Survey Monkey or a similar service for your questionnaire. You may have to pay a (small) fee for the branching feature, but it may be more efficient that trying to use Excel. And, you can still use Excel for analyzing the data and creating charts. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "jammyjamms" wrote in message ... I'm trying to create a yes/no questionnaire in excel and need to incorporate some additional criteria: 1) Questions are broken into categories. If the 1st response to any given category is"no", then all other questions of the same category are greyed out, not displayed, or automatically answered for the respondent. 2) If any answer is "yes", then a separate worksheet lists certain requirements pertaining to the original question. At this time I have IF/THEN statements such as IF B5="yes" then display the contents of <data worksheet However, this leaves large blank areas if a respondent answered "no" for one category but "yes" for the next. 3) The requirements listed should then be formatted for easy printing or exporting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Providing a reference to another cell in a different workbook | Excel Worksheet Functions | |||
Material Requirements Plan (MRP) and Capacity Requirements Plan (C | Excel Worksheet Functions | |||
Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
Providing a way to return to the place before you followed a link. | Excel Discussion (Misc queries) | |||
Providing Toolbars to Workgroup | Excel Discussion (Misc queries) |