wolverin20
New Member
- Joined
- Mar 18, 2014
- Messages
- 3
I have a survey built, which I need to fill out 14 times. Each time the survey is filled out it needs to be on it's own worksheet. The survey, however, is still being refined, so I need any text changes to the root/master sheet to carry through to all the survey sheets. A microsoft query and data refresh won't work as I need to be able to insert rows to the MASTER sheet and still maintain the answers previously provided in survey sheets.
Based on the example data below (I do not yet have the rights to attach files), I need the ability to do the following:
1) Any change to the text contained in a Question or Answer on the MASTER needs to update on the survey sheets
2) If I insert a new answer row into the MASTER (above Q1A3, for example) that needs to update on the survey sheets
3) Any "x" in column B in the survey sheets needs to stay to the right of their appropriate answer (i.e. shift down when a new row is inserted to the MASTER).
Unfortunately the data is rather complex and extremely long, so I don't have much leeway with the overall layout/formatting
Master Sheet:
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[/TR]
</tbody>[/TABLE]
Survey 1:
[TABLE="width: 128"]
<tbody>[TR]
[TD="colspan: 2"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Survey 2:
[TABLE="width: 128"]
<tbody>[TR]
[TD="colspan: 2"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
wolverin20
Based on the example data below (I do not yet have the rights to attach files), I need the ability to do the following:
1) Any change to the text contained in a Question or Answer on the MASTER needs to update on the survey sheets
2) If I insert a new answer row into the MASTER (above Q1A3, for example) that needs to update on the survey sheets
3) Any "x" in column B in the survey sheets needs to stay to the right of their appropriate answer (i.e. shift down when a new row is inserted to the MASTER).
Unfortunately the data is rather complex and extremely long, so I don't have much leeway with the overall layout/formatting
Master Sheet:
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[/TR]
</tbody>[/TABLE]
Survey 1:
[TABLE="width: 128"]
<tbody>[TR]
[TD="colspan: 2"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Survey 2:
[TABLE="width: 128"]
<tbody>[TR]
[TD="colspan: 2"]Question 1[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 2[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Question 3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
wolverin20