| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel form. Need data extracted to spreadsheet each time a form co
HI,
I have produced a form in Excel that uses drop down boxes etc. When someone comletes the form I would like the information to also be transposed/ recorded onto a spreadsheet that has columns corresonding to all the form fields and will add a new line for each form so t the end of the day(year) I can see how many 'activities' occurred for each field etc. How is this done? The form is for staff to easily enter occurances but I then need this data kept for analysis like how many. Look forward to your kowledge. Regards Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfer data from excel form to a spreadsheet | Excel Discussion (Misc queries) | |||
| Can't send data from form to spreadsheet. | Excel Discussion (Misc queries) | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| How do I create a 1pg form for each row of data in a spreadsheet? | Excel Discussion (Misc queries) | |||
| How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions | |||
Threaded Mode
