Consolidating survey results excel jejak rasul online dating

21-Nov-2017 04:52

However, in this case I was limited to MS Word – the doc / docx survey was to be sent via email to clients/users and consolidated. Below I explain my approach of making a survey in Word and how to easily consolidate the results using VBA macros (next page of this post).

Most people don’t put enough effort into designing their surveys – sloppy designs, messed up document structures or simply frequent typo’s and misspelled questions.

Now that you have your survey ready it’s time for consolidating the results.

And at the same time sets the zoom to the same setting on all the worksheets.

Recently I stumbled upon an issue of creating a quick survey for clients/users.

Usually you would want surveys set up in a dedicated web application like Google Forms or Survey Monkey. I created the survey using MS Word Content Controls (text fields, checkboxes etc.) and Active X objects (for option / radiobuttons only). The code is reusable for virtually any survey created this way.

Path) Set ws = Active Sheet curr File = Dir(folder & "/") 'Loop through survey results row = 2: col = 1: is Header = False Do While curr File "" Set curr Doc = w App. Open(folder & "/" & curr File, Read Only:=True) Load File ws, curr Doc, is Header, col, row curr Doc.

Close Save Changes:=False is Header = True row = row 1 col = 1 curr File = Dir() Loop Finally: w App. The customer first combined all the survey sheets using the Consolidation Assistant into one workbook, with each sheet renamed from "survey" to the manager names.