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" wrote in message
...
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