Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collecting data
I have an evaluation sheet created in Excel 2003. I have a number of
questions which have responses eg. poor, fair, good, excellent etc. These will be answered by ticking in an €˜ActiveX Check Box. Beside each question the respondent can add comments, for this I used the €˜ActiveX Text Box with a scroll bar. We usually only send this form out to random attendees and getting about 5-10 responses. It was not difficult to collect the data for such a small number. What has happened now is that a colleague has sent the form out to everybody that attended one of our presentations and to date we have received over a hundred responses. Had I been aware of this I would have put some backend data collection on the form before it went out. My problem is how do I collect all this data without having to go through each sheet manually. Can I create another sheet and then paste the evaluation sheets into it and collect the data that way somehow. I am appealing to you gurus to help me out please. Thanks Lynda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collecting data | Excel Discussion (Misc queries) | |||
Help Collecting Data | Excel Discussion (Misc queries) | |||
help collecting data. | Excel Discussion (Misc queries) | |||
help collecting data please! | Excel Discussion (Misc queries) | |||
collecting data | Excel Discussion (Misc queries) |