Streamlining questionnaire analysis

[englishmustard]

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

 

[Dave Peterson]

I think I'd use a bunch of linked cells (back to the optionboxes).

And then create a new worksheet (probably hidden) in the survey workbook.

It would consist of at least 3 columns.

A: Name/id of survey taker
B: Question #
C: Linked cell value (response)

Then when I got all those surveys back, I'd put them in a dedicated folder and
then use code to open each workbook and extract the data from that hidden sheet
and combine it into one giant worksheet.

Ron de Bruin has tons of sample code that can do this kind of combining:
http://www.rondebruin.nl/copy2.htm

========
You may want to even look at alternate applications. Maybe there's a way to do
this via the web/html stuff (way beyond me). Or even dedicated survey
applications????

 

[englishmustard]

Thanks for the tips - there's plenty to think about!