Hi
don't know where to start sorry about lenght of post
I have a worksheet with 31 survey questions on it
question 1 starts on row 5.
column 1 question number
column 2 the question
column 3 first choice
column 4 second choice
colunm 5 third choice
column 5 forth choice
column 6 fith choice
When person completes the survey they select a checkbox under the culmn which represents their answer and when they are finished they click a done button on the sheet which save thier results to a folder call "viewpoint" with a random name.
The mastersheet looks the same as the surveysheet except there are no check boxes in the columns to select a answer. I'm trying to figure out a way to create a macro that will pull the results from every file in the folder "viewpoint" and add them together and place the end results in the correct column
Example option 1 option2 option3 option4 option 5
Question 1 - I like my job 5 2 3 4 5
so five people selected option 1 and 2 selected option 2 and so on
don't know where to start sorry about lenght of post
I have a worksheet with 31 survey questions on it
question 1 starts on row 5.
column 1 question number
column 2 the question
column 3 first choice
column 4 second choice
colunm 5 third choice
column 5 forth choice
column 6 fith choice
When person completes the survey they select a checkbox under the culmn which represents their answer and when they are finished they click a done button on the sheet which save thier results to a folder call "viewpoint" with a random name.
The mastersheet looks the same as the surveysheet except there are no check boxes in the columns to select a answer. I'm trying to figure out a way to create a macro that will pull the results from every file in the folder "viewpoint" and add them together and place the end results in the correct column
Example option 1 option2 option3 option4 option 5
Question 1 - I like my job 5 2 3 4 5
so five people selected option 1 and 2 selected option 2 and so on