Anyone any good on excel?

[mattyj1085]

I have done a survey of 300 people and I need to collate all the data into a table, I thought about trying to create a form to enter the data into, ideally I would like to cover 7 questions all with set multiple choice answers.

I tried to create a form with tick boxes next to each answer with a submit button at the bottom, but I don't have any idea on the coding I need behind these box's and button in order to get it to populate a table that I can later use to draw graphs from.

Is there a simply way where I can just tick the relevant boxes and press a button and it adds the results to a table and just continue doing this until all 300 have been inputted?

Any help or guidance appreciated

 

[tres]

that's the world of VBA
do-able, but not recommended for a starter

use drop down boxes and cell inputs instead of forms

 

[uv]

I have done a survey of 300 people and I need to collate all the data into a table, I thought about trying to create a form to enter the data into, ideally I would like to cover 7 questions all with set multiple choice answers.

I tried to create a form with tick boxes next to each answer with a submit button at the bottom, but I don't have any idea on the coding I need behind these box's and button in order to get it to populate a table that I can later use to draw graphs from.

Is there a simply way where I can just tick the relevant boxes and press a button and it adds the results to a table and just continue doing this until all 300 have been inputted?

Any help or guidance appreciated

Would probably be much easier to do using a wizard in Access, rather than Excel

 

[Dolph]

Would probably be much easier to do using a wizard in Access, rather than Excel

What this man said. This is a database job, not a spreadsheet one.

 

[A[L]C]

What this man said. This is a database job, not a spreadsheet one.

nah, excel can handle that easily!

 

[Dolph]

nah, excel can handle that easily!

But Access will handle it much better. It's not a case of Excel not being able to do it, but which is the better solution, when you include searching/query building, the database is a much better solution for storing the information, the spreadsheet is much better at displaying it in a report though.

 

[A[L]C]

But Access will handle it much better. It's not a case of Excel not being able to do it, but which is the better solution, when you include searching/query building, the database is a much better solution for storing the information, the spreadsheet is much better at displaying it in a report though.

Yeah true.

300 people isnt a lot, so I think excel may be better. Thats only 301 rows (inc header) and 8 columns.

 

[ovia]

I would have to say to go with the Excel route and just create dropdown lists.

You could go the access route depending on how much experience you have but tbh for this i would simply go excel. (And i enjoy making random access databases for no reason and still suggest excel being the easiest route )

 

[A[L]C]

I would have to say to go with the Excel route and just create dropdown lists.

You could go the access route depending on how much experience you have but tbh for this i would simply go excel. (And i enjoy making random access databases for no reason and still suggest excel being the easiest route )

I think a userform would be easier than drop downs to actually record the data

 

[tres]

I think a userform would be easier than drop downs to actually record the data

i agree
but to actually make the forms and a tiny bit of VBA to copy the info over to a seperate data sheet is much less effort and know how that to create it all in userforms