I want a Master Worksheet that other Workbooks use as a template?

[coreyb66]

I want to have one Master Worksheet be my Master Cash Register Reconciliation
sheet. This Master Worksheet will be used 31 times to form a monthly
workbook. An annual folder will contain 12 Workbooks.

I would like to have the original Master Worksheet copy, itself with
formatting, to each worksheet within each of the workbooks created?

Also, Could changes to the made to the master Worksheet always update any
sheet that is a child to it?

i am pretty novice and appreciate the help.

Corey

 

[pdberger]

You can save it as a "template". >File>Save As> then choose a file type of
'template'. Then, your users can >File>New then choose From Template, and
navigate to where the template is.

If you make changes to the template, any new workbook made from it after
that point will incorporate the changes, but not ones made before.

HTH

 

[coreyb66]

thanks PD,

I got it to work as a template and my master opens as default in all new
startups.

I have my excel set to open 31 worksheets in each new workbook, but it is
not recognizing this setting as the remplate is used, as I would like to have
the tempmate in-fill all 31 worksheets with the same template, which is
currently on sheet 1.

Do you know how I can copy sheet one across all 30 other sheets and keep
margins and formatting intact?

Thanks

 

[pdberger]

There are two ways --

Write a macro that, when the workbook opens, copies out 31 worksheets. Much
easier would be to just save the template workbook with the 31 worksheets the
way you want them, no?

HTH