Hi,
Im carrying out a social survey and to make my life easier Im inputting interview answers directly into excel. The format is as follows: questions are listed vertically in column A and answers will be typed in adjacent columns. eg
how many children do you have? ----------3
do you own a Tv?----------------------------yes
do you own a cell phone?-------------------yes
etc
etc
Each household will have a separate questionnaire, and each questionnaire will be a separate sheet on the same file.
To make analysis easier, is there a simple macro that will allow me to extract each row of information to a separate sheet so that I end up with a separate sheet for each question?
Many thanks in advance,
Doug
Im carrying out a social survey and to make my life easier Im inputting interview answers directly into excel. The format is as follows: questions are listed vertically in column A and answers will be typed in adjacent columns. eg
how many children do you have? ----------3
do you own a Tv?----------------------------yes
do you own a cell phone?-------------------yes
etc
etc
Each household will have a separate questionnaire, and each questionnaire will be a separate sheet on the same file.
To make analysis easier, is there a simple macro that will allow me to extract each row of information to a separate sheet so that I end up with a separate sheet for each question?
Many thanks in advance,
Doug