T
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
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