Hi there

I am setting up a layout or template on the main (master sheet) sheet. All
other sheets on the same workbook will have the similar layout. The question
is, what can i do so that whenever i add additional table/s on the main
sheet, it will automatically update the layout for the rest of the sheets
within the same workbook. Most additional tables will be done on the new rows
(e.g bottom of the page). This will save the time on updating each sheets. I
know i can copy from main sheet (the additional tables/layouts/templates) and
paste it to all other sheets (by selecting all the sheets).

Is there an alternative solution?

Thanks in advance for the assistance.

In other words, what you add to the master worksheet, you also want to be
added to the other worksheets, right.

Try this. Select all the worksheets: go to last worksheet, now slide to
first worksheet, hold Shift button and left click on first worksheet
(Master); all worksheet will be selected.

Now while on the master worksheet, whatever you create or add to this
worksheet, will exactly be added to all the other selected worksheets.

Not sure if this is what you wanted. Hope this helps. Good luck.

Eduardo

****************

"Dave" wrote:

Hi there

I am setting up a layout or template on the main (master sheet) sheet. All
other sheets on the same workbook will have the similar layout. The question
is, what can i do so that whenever i add additional table/s on the main
sheet, it will automatically update the layout for the rest of the sheets
within the same workbook. Most additional tables will be done on the new rows
(e.g bottom of the page). This will save the time on updating each sheets. I
know i can copy from main sheet (the additional tables/layouts/templates) and
paste it to all other sheets (by selecting all the sheets).

Is there an alternative solution?

Thanks in advance for the assistance.