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: 13

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,657
Messages
5,838,635
Members
430,558
Latest member
Krampus

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