collecting data

Hi,

I need to create a simple questionaire to be sent to a group of people. I
would like to automate as much as i can of this process to the point where
their answers are saved for reporting purposes in one place...can anyone give
me ideas? can this be done in excel or should i look at other microsfot
office programs?

thank you!

How would i collect the data without having to enter all of the data
submitted? How can i set it up so that an automatic emails is generated once
users have filled out the form?

"mrice" wrote:

>
> Excel could be good for this as it gives you a chance to put validation
> on cells (for instance if you are looking for just Yes/No answers) and
> a check before saving that all answers have been completed.
>
> You could even get it to auto e-mail a copy of the completed sheet to
> you.
>
> Martin
>
>
> --
> mrice
>
>
> ------------------------------------------------------------------------
> mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
> View this thread: http://www.excelforum.com/showthread...hreadid=532959
>
>

In the end you will have a separate workbook for each person involved.
You could (would have to) develop a macro or other code to process the
information received into a common spreadsheet and/or common resource