I work in a small company who, for compliance need to complete a small set of yes/no type questions. We complete about a dozen of these each week on a paper form and then the answers are then input into excel to keep the results and create some colourful graphs.I have been charged with trying to improve this process!

What I would like some help on, is how I can replicate the form on an excel sheet and get the data that is input in the form, to somehow store itself in a seperste area so that we can keep a complete record.

I have tried numerous searches on the Microsoft site, but I'm afraid that I'm really not understanding and am hoping that someone may be able to give me a real idiot guide type explanation on how I can about this little project.

We use offIce 2010, which I think is important to let you know. If anyone can help I would be extremely grateful.

Thanks in advance.