Hi

I have a 50 replies from a questionaire.. they have all filled in with the number 1 for their choice. (all the workbooks is in the same folder)

I'm trying to use an empty template of this questionaire, and have a macro sum up all the responses of the other workbooks in this template.

Answere range is "C9:G19".

I've tried for two days now and Im about to give up... can some of you give me some advice please.

Thanks