Importing Answers from an Excel Based Questionnaire Into Master Data Sheet

[sincy]

If i was to design and send out 1000 questionnaires/surveys in Excel format, is there an easy way to import the responses into my Master source data sheet?? The responses would be closed ended - Yes, No .... Low, Medium, High etc.

I know copy/paste seems like an obvious answer but that would mean the layout of the Master sheet being the same.

Would there be a way to import all the responses as different sheets in the same workbook and then tell the Master sheet to drag all the appropriate responses into the right cells??

Is there any similar way to do this with Word too?

Thanks!!!

 

[igold]

Are you still interviewing for this job? What happens if you get it...

https://www.mrexcel.com/forum/excel...-randbetween-avoid-clashes-other-columns.html

 

[sincy]

Are you still interviewing for this job? What happens if you get it...

https://www.mrexcel.com/forum/excel...-randbetween-avoid-clashes-other-columns.html

ha... lots of manual data entry i suppose. The questions I've asked are not pre-requisites for the work, but they might make it easier.

Thank you though...

 

[igold]

Good luck!!