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