Saving Data from a questionnaire

[Tel]

Hi Guys,

Here's what I want to do.

I have a questionairre for my managers that I would like to represent in a
form. These Managers will have multiple entries onto the same form (I'm
undertaking a data flow exercise). Some of the answers will require free
flow text and some a yes no pick list.

I want to give each managers a form on sheet 1 and this populate a table in
sheet 2. Then, when they hit "submit" it clears the form but leaves the data
on sheet 2.

I don't want to use access due to bandwidth issues across our network. I'm
stuck with Excel.

I've tried a macro but when the form is cleared it clears the table.

Ultimately I will collate all the responses onto an additional table and
apply risk matrix criteria against it (using conditional formatting).

Any help would be greatly appreciated.

Thanks

Tel

 

[Tel]

Forgot to mention, I'll need a complete idiot guide to achieve this (if
indeed it is possible).

Thanks

Tel

 

[Mike Middleton]

Tel -

I suggest that you use an online service for the questionnaire, e.g., Survey
Monkey, download the results, and then use Excel to summarize and display
the results.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Tel]

Thanks for that Mike, I do see where you're coming from.

Bit of a problem there as many, if not most, of the replies are likely to be
embarrassing and will be 'commercial in confidence' as a minimum. Therefore,
I would rather stay away from using a third party at this stage.

Regards,

Tel