View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Update multiple sheets

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.