Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Providing a reference to another cell in a different workbook Darren Excel Worksheet Functions 2 May 25th 07 11:32 PM
Material Requirements Plan (MRP) and Capacity Requirements Plan (C Tricia Young Excel Worksheet Functions 1 February 1st 07 07:55 AM
Material Requirements Planning-MRP/Capacity Requirements Planning- Tricia Young Excel Discussion (Misc queries) 1 February 1st 07 07:22 AM
Providing a way to return to the place before you followed a link. Graham Trickey Excel Discussion (Misc queries) 1 October 18th 05 03:36 PM
Providing Toolbars to Workgroup Sprinks Excel Discussion (Misc queries) 2 January 12th 05 02:51 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"