MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to adjust template

Posted by Rayn on May 09, 2001 9:53 PM


I am working on about 20 workbooks. all the work books
are the same in terms of structure (Template that gets filled with
data by different people). i would like a macro, so when i make changes
to one template, the rest of them get updated with the same change automatically.
this is a hard task for me, i can not figure it out.

Thank you for your help.


Posted by Steve W on May 09, 2001 10:12 PM

Hi Rayn
How about right clicking on one of the sheet tabs and selecting select all, now make your changes then rightclick sheet tab again and selsct ungroup sheets.
Hope this helps
steve w

Posted by Rayn on May 09, 2001 11:12 PM

Hi steve what i have is seperate files not sheets
sorry if i did not explain it properly

Thank you