Consolidate Survey
With this tool you can easily consolidate survey results. Just follow these two steps: 1. Select survey questions to consolidate. 2. Select questionnaires to be consolidated.
1.Select survey questions to consolidate. Open the Consolidate Survey dialog box. This dialog is similar to Create Survey, but this is not used to create surveys but rather to capture the questions of the existing survey to use them as a template.
First you have to be on the survey to load the questions using textboxes.
To capture the data from the survey questions, proceed as follows:
Then click on Next to select the questionnaires to be consolidated
2.Select questionnaires to be consolidated The dialog box will automatically load all open books listed. However, if you think that none of these books are part of the surveys to be consolidated, you can select Rem. All to clear the list and use the Add… button to look for Excel books containing the filled-out questionnaires to be consolidated. Once the books have been loaded, select the sheets to be consolidated and the click on Consolidate Survey.
Below you can see the consolidated report of all selected questions in all selected surveys. This consolidated data becomes a valuable input for whatever use you can make of it, such as drawing charts, find percentages, etc.