View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
englishmustard
 
Posts: n/a
Default Streamlining questionnaire analysis


I would be grateful for any help and advice with this problem. I have
been given the task of designing and distributing a survey
questionnaire using Excel. I anticipate getting 200-300 responses via
email - all of which have to be collated and analysed. Please does
anyone have any tips for efficiently collating input from individual
worksheets into a master worksheet? I was thinking initially of using
check boxes in question response categories on the individual
worksheets but do not know how to capture the results effectively in
the master worksheet. The responses to questions will be subject to
later statistical analysis. Please could someone point me in the right
direction?
Many thanks.


--
englishmustard
------------------------------------------------------------------------
englishmustard's Profile: http://www.excelforum.com/member.php...o&userid=31804
View this thread: http://www.excelforum.com/showthread...hreadid=515273