Hello,

I have a problem, I have made a poll form as a matrix in Excel and submitted to 100 colleagues. They have replied by filling this form. What I have to do now is to collect their answers in one excel summary sheet.
How can I do this automatically or what is the easiest way?
The idea is to have a macro or program that opens every Excel form, collect the data from it and then put it all togheter in a summary sheetand do some basic statistic calculation.
Is out there a tutorial for this? O a software package that do this?

Thanks!

jvcastel