generating "meaningful" analysis...

[Andreass]

hi all -

i am currently in the process of creating a questionnaire on excel including drop down options, etc.

how can i configure the cells in order to get a summary of my findings? i.e. is there a way to get the quantity of "yes" or "no" answers to particular questions with a press of a button???

also, is it somehow possible to receive this information via email? somehow "automated" by excel???

any advice is much appreciated.

thanks in advance, andreass.

[arthurbr]

hi all -

i am currently in the process of creating a questionnaire on excel including drop down options, etc.

how can i configure the cells in order to get a summary of my findings? i.e. is there a way to get the quantity of "yes" or "no" answers to particular questions with a press of a button???

also, is it somehow possible to receive this information via email? somehow "automated" by excel???

any advice is much appreciated.

thanks in advance, andreass.

Welcome to the board,

do you really need to use XL for the job?
Although it can be done, Access might be easier.

[Andreass]

unfortunately, i have never used access before