If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a form that populates an excel sheet - can it be done?
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 |
#2
|
|||
|
|||
Creating a form that populates an excel sheet - can it be done?
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 "Iduna" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|