tarheels05
New Member
- Joined
- Jul 28, 2011
- Messages
- 3
I am trying to build a survey in excel for over 20 people to take. I’ve developed the survey using 4 option buttons within a group box (all from the control toolbar) per question. There are 45 questions. I also have a tab for store all the responses so I can run reports from the single data tab.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
Does anyone know if / how I can get a name selected from a combo box (also from the control toolbar) to store the responses to their option button selections to their name in the data tab. I would need to change each option button’s cell link for each different name.
<o> </o>
I envision people able to open the excel file, choose their name from the list, take the survey and then save. Once everyone takes the survey if I go to the data tab then everyone’s responses are saved and I can run my reports.
<o> </o>
Help would be greatly appreciated!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>Does anyone know if / how I can get a name selected from a combo box (also from the control toolbar) to store the responses to their option button selections to their name in the data tab. I would need to change each option button’s cell link for each different name.
<o
> </o>I envision people able to open the excel file, choose their name from the list, take the survey and then save. Once everyone takes the survey if I go to the data tab then everyone’s responses are saved and I can run my reports.
<o
> </o>Help would be greatly appreciated!
