collecting data

[Guest]

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!

 

[mrice]

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

 

[Guest]

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?

 

[Ron2005]

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