Automating Different Survey Results

Does anyone have any idea on how to facilitate the preparation of survey results?

Our survey results are downloaded from our survey online facility (some facility when it can't even produce the report :sigh. These surveys are about the services of the different support groups of our company. So each survey has its own set of questions. The backend process of translating these results is quite tedious and I've been thinking of how to automate it ... I know that there is a better way. I am using Excel but only the standard features such as countif, sumproduct, pivot, charts. But still it consumes a lot of time just preparing one report.

Any ideas?

Sara, my recommendation would be to set up a template page with
established column headers, below which you could dump the raw data
from the survey. Then use Excels, Insert > Name > Create menu item to
name each column all at once. Finally, create formulas and analyses
based on the named ranges in other worksheets. All your tables and
charts should automatically update. The key here is that the analysis
doesn't change from survey to survey.

I'm not sure what to tell you if that's not the case. You could, I
suppose, create some VBA that leverages the named ranges and drown down
boxes that would select "operations" like average, median, high, low,
frequency tables, etc. and then have the code generate tables and
graphs, but that seems like overkill.

ryan

Sara_Chase wrote:
> Does anyone have any idea on how to facilitate the preparation of survey
> results?
>
> Our survey results are downloaded from our survey online facility (some
> facility when it can't even produce the report :sigh. These surveys
> are about the services of the different support groups of our company.
> So each survey has its own set of questions. The backend process of
> translating these results is quite tedious and I've been thinking of
> how to automate it ... I know that there is a better way. I am using
> Excel but only the standard features such as countif, sumproduct,
> pivot, charts. But still it consumes a lot of time just preparing one
> report.
>
> Any ideas?
>
>
> --
> Sara_Chase
> ------------------------------------------------------------------------
> Sara_Chase's Profile: http://www.excelforum.com/member.php...o&userid=35616
> View this thread: http://www.excelforum.com/showthread...hreadid=563159

Hi, Ryan.

That's exactly what I did with our current survey results. However, it still seems to be too much ... well, anyway probably just this survey period. I will see if it's going to save us time on our next survey period since all the templates for the 6 departments are all set-up.

Thanks.