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!

collecting data
 

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

collecting data
 

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

collecting data
 

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