Help on templates

[cory johnson]

I don't expect a complete answer, but if anyone can tell
me a document to read - or whatever - about creating
templates. I'm still a novice.

What happens to me is that I've named ranges and tables on
Sheet1. When I create a number of additional sheets
corresponding to months, the formulas on these sheets
reference Sheet1 and not the sheets upon which they
reside. How could I create formulas that will reference
the sheets upon which they are entered?

And is there a way to simply insert this customized sheet
whenever I should need it?

Again, I'm willing to purchase a book or read some
discussions on this topic.

Any help is greatly appreaciated.

 

[Dave Peterson]

How are you creating the new sheets?

If you rightclick on the "master" worksheet tab and select "move or copy" and
then copy this sheet, the named ranges will kind of move over to the new
sheet--actually they'll be worksheet level names--just what you want.

When you create a name, you have to decide what level name you want. There are
workbook level names and worksheet level names.

For instance, if I select Sheet2:

Insert|Name
sheet2!test1
in the Names in Workbook box

And
=sheet2!$a$1
in the refers to box

If I include that worksheet name in the "names in workbook" box, then this makes
it a worksheet level name.

A very useful tool if you're going to work with names:
Jan Karel Pieterse's (with Charles Williams and Matthew Henson) utility
"Name Manager.xla" from http://www.bmsltd.co.uk/mvp/

=====
On the other hand, if you just insert a new worksheet (with no range names at
all) and those names on the "master" worksheet are workbook level, then your
formulas will refer to that master sheet.

So I guess it boils down to:

If you copy the sheet, the names (adjusted to include the sheet name) will come
over.

If you insert a new sheet, you'll have to create new worksheet names yourself
(based on the addresses in the master worksheet?????)

 

[Guest]

Dave; Thanks alot. I see what you mean by workbook level
and worksheet level names and that's where my problem is.
And thanks for the reference as well. I will check it out.