Creating a form that populates an excel sheet - can it be done?

[Iduna]

I am in need of creating a form with drop down boxes that can be filled in
easily. Then I am in need of it taking the information inputted and
accumulating it in a worksheet which I can use as an analysis which would
have run over a number of month..... that sounds confusing!

Let me explain:
I have a number of employees that have 'Audits' completed on them to ensure
correct procedures and quality. They also show if training is needed and
where performance is low.

I am wanting to get this form (which is currently on paper) into Excel (or
what ever will be best to use) and create drop down boxes that can be filled
in easily. Each question has a number of set answers, but mainly its either
'correct' or 'incorrect'. When this form is filled in, it then adds the data
to a spreadsheet so it can be analysed. This spreadsheet will be for
individuals, so it will accumulate the data gathered on the employees over a
few months. I guessed that a drop down box with their names in will be
needed to link to each persons accumulate spreadsheet and then it can all be
linked together to give an overall picture of all the employees together.
Also I need it to be on a monthly basis so I guess there would be a month
drop down box too.

I am a tad overwhelmed! I am after the basic form making and linking to a
spreadsheet. The rest should be simple after the initial form and links are
inputted.... but how to do it? I feel I might be looking in the wrong place!

Can anyone help?

Iduna

 

[Jeanette Cunningham]

Iduna,
you don't say whether or not you already have a database that you use for
audit info.
If you don't have such a database, you can set this up in a spreadsheet.
You can set up drop down boxes in excel in a worksheet.
Use excel help to find out how to set up the drop down boxes.

If you do have an existing database, yes it is possible to do what you want.
It takes a bit of coding, but can be done if you are comfortable with doing
the coding.


Jeanette Cunningham -- Melbourne Victoria Australia