CuriousGeorg
09-25-2014, 01:31 AM
hi,
I've got a "design" issue here. I've been tasked to replicate a survey from Word in excel so that they can add the information and then analyse it later.
There's approximately 7 questions which are ALL free format questions (no 1-5 scales etc). I was curious as to the best way around this.
Of course I could use a userform to input the information but not sure this is the approach they would like.
Is there a way of emulating a user form on the excel sheet and then this then auto stores on say sheet 2 in the same workbook?
I've got a "design" issue here. I've been tasked to replicate a survey from Word in excel so that they can add the information and then analyse it later.
There's approximately 7 questions which are ALL free format questions (no 1-5 scales etc). I was curious as to the best way around this.
Of course I could use a userform to input the information but not sure this is the approach they would like.
Is there a way of emulating a user form on the excel sheet and then this then auto stores on say sheet 2 in the same workbook?