We are doing an ongoing patient satisfaction survey where I work.
Each patient is asked to fill out a form with 15 quick questions regarding how their visit went. I would like to do this in excel because everything is in portuguese and I cant seem to find any off the shelf software that will allow me to configure our survey.

The question is simple: How do you make a simple data entry form in excel.
When the clerk types the number 1 into box a, box b, c, etc then hits enter,
All those numbers are passed to another spreadsheet where they are added to the existing totals, (if you follow me). I know I should be thinking Access for this but I havenít messed with it for some time and I think it may be a bit more complex then we need. Also I donít want to learn Access all over again, if I can help it.

Actually, unless you enjoy writing Visual Basic for Application code, this would be easier in Access because Access is built to do just this little or no programming. I might be able to rough out a spreadsheet (in English, I'm afraid) and e-mail it to you, if you're interested. Actually, the idea of doing that sounds kind of like fun, but then again, I'm the kind of deviant who does enjoy writing VBA code. What I'd do is set the form up so that when it's submitted, 1 is added to the total number of responses for each question clicked.

I might be able to rough out a spreadsheet (in English, I'm afraid) and e-mail it to you, if you're interested.

Siege That would be super cool, I could change the language later. My e-mail is listed in my profile. Just let me know (either in this forum, or by E-mail) what you need to know about the questionnaire, If you would like I could scan it and send it off to you so you can get an idea of how many fields would be needed for each question.

P.S. I didnít post this to GQ because I know there will be more then one correct answer.

Thanks again!

__________________
You mess with me, you mess with the whole trailer park!

ST's vBulletin 3 Responsive Styles

Our newly refreshed styles in 2017, brings the old vb3 to the new level, responsive and modern feel. It comes with 3 colors with or without sidebar, fixed sized or fluid. Default vbulletin 3 style made responsive also available in the pack.
Purchase Our Style Pack Now