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

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

Thanks

Tel

"Tel" wrote:

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 -

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

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

"Mike Middleton" wrote:

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