Best Way to Represent Paper Survey Question in Excel

[lyndy256]

Hi,

I am creating an Excel spreadsheet/template for data entry based on a paper survey. I am having trouble figuring out how to best represent the two highlighted questions on the attached survey.

The questions are: No of Key Informants, where the data entry clerk needs to specify each informant type and the number.

The second is question number 6, where data entry clerk needs to indicate what development projects are occurring in the village tract being assessed.

It seems a bit clunky to break this question up into multiple columns but is there any other way to do this in Excel when the survey has multiple possible answers and more complex question types such as these?

Any advice would be greatly appreciated.

Regards,
Lyndy

[lyndy256]

I have figured this out on my own.

My apologies for violating forum rule # 8.

See http://www.excelforum.com/excel-form...12#post3247012

Lyndy

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[lyndy256]

I solved this myself by using a macro to allow the user to insert multiple responses into one cell.

The code to do this is below:

Please Login or Register  to view this content.

Thanks,
Lyndy

[arlu1201]

lyndy,

I have corrected the code tags for you. You need to place [noparse][code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

[lyndy256]

Thank you! I have been hitting the # sign before and after I paste code but it doesn't work. Not sure what I am doing wrong.

1. I cut the code from my work book.
2. I paste code into my thread
3. I place # before and after code.

Where am I going wrong?

Please advise so I can correct this.

Best,
Lyndy