LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to update hyperlinks through multiple sheets but can't Billznik Excel Worksheet Functions 1 February 28th 12 06:19 AM
Update multiple sheets at once Sinner Excel Discussion (Misc queries) 1 September 2nd 07 07:54 AM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
Update all Sheets Rich Excel Discussion (Misc queries) 0 May 16th 06 04:02 PM
How to update links between wk sheets nander Excel Worksheet Functions 1 August 25th 05 03:57 PM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"