Master sheet to control only basic structure of slave sheets

emmo1210

New Member
Joined
Jul 31, 2020
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
I have a Master worksheet (template) that contain only one column of data (common to all sheets) and one row (Row 1 headings common to all sheets). This sheet is otherwise unpopulated of data, see worksheet attached.

I wish to use this Template to control the structure of all the 'slave' sheets. That is to say if a column / row is added to the master it will add the same column / row including heading to all the 100's of slave sheets. Also if any cell in the common column / row is edited in the Master, same changes will be affected in all sheets.

On the slave sheets I can populate all the other cell data specific to it.

I have been around the internet and have not found a suitable solution. Basic linking of cells does not work as it does not allow adding/deleting or rows.

I don't wish to use the 'select all' sheets and add row as, with 100's of sheets, I have found it is too easy to make mistakes with hidden sheets etc. and mess up a lot.

Grateful for any input
 

Attachments

  • Master test.jpg
    Master test.jpg
    213.9 KB · Views: 10

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

emmo1210

New Member
Joined
Jul 31, 2020
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
Cell Formulas
RangeFormula
J2J2='[EMG Magento Excel.xlsm]Configs-Alu'!U216& ""
J3:J16J3='[EMG Magento Excel.xlsm]Configuration'!G2
J17:J18J17='[EMG Magento Excel.xlsm]Configuration'!G17
 

Watch MrExcel Video

Forum statistics

Threads
1,127,585
Messages
5,625,648
Members
416,124
Latest member
DeMoNloK

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
Top