Simple Survey Tool in Excel with specific logical algorithm (calculation methodology)

[happyexcelling]

Hello experts,


I need a quick support from experts in this forum.

I am in need to create a simple Excel Tool that should have the following:
1) Questions with Answer Options
2) Set of Questions would be under some categories which will have some weightages
3) Each Answer Options will have some specific scores
4) After completion of filling the questionnaire, the result should reflect in an overall score (may be out of 100)


Can someone help me on this?
I think a re-usable macro enabled sheet (in the similar line) should work with some editing/customization that I will do.


Thank you in advance!


Cheers.

 

[Macropod]

Cross-posted at: Building a simple Survey Tool in Excel with some specific logical algorithm

Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html