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. |
Update multiple sheets
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. |
All times are GMT +1. The time now is 10:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com