Update worksheet surveys based on changes to a "master sheet"

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:
Question 1
A1
A2
A3
A4
A5
Question 2
A1
A2
A3
Question 3
A1
A2
A3
A4
A5
A6
A7
A8

<tbody>
</tbody>


Survey 1:
Question 1
A1
A2x
A3
A4
A5
Question 2
A1x
A2
A3
Question 3
A1
A2
A3
A4x
A5
A6
A7
A8

<tbody>
</tbody>


Survey 2:
Question 1
A1
A2
A3
A4x
A5
Question 2
A1
A2
A3x
Question 3
A1
A2x
A3
A4
A5
A6
A7
A8

<tbody>
</tbody>


Thanks,
wolverin20
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,214,833
Messages
6,121,868
Members
449,053
Latest member
Mesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top