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