Inserting Multiple Worksheets?

[Mr Zero]

Thanks for the reply. Don't know how to use code so I'll just renam
manually. Another question...

I am running a summary worksheet that takes the averages of specifi
cells in a range of other worksheets i.e.
=AVERAGE('11-04-04:11-10-04'!C3). Is there a way to automaticall
update this range every time another worksheet is added to the end o
the range

 

[Gord Dibben]

Zero

Insert a dummy worksheet named Start before the 11-04-04 sheet.

Insert a dummy worksheet named End at end of sheets.

=AVERAGE('Start:End'!C3)

Insert all new sheets between these two.

Gord Dibben Excel MVP

 

[Gord Dibben]

Too bad you won't learn how to use code.

Makes Excel life so much easier.

Gord Dibben Excel MVP

 

[Darlene Kupke]

Thanks for the reply. Don't know how to use code so I'll just
renam manually. Another question...

I am running a summary worksheet that takes the averages of specifi cells in
a range of other worksheets i.e.

=AVERAGE('11-04-04:11-10-04'!C3). Is there

a way to automaticall

update this range every time another worksheet is added

to the end o

the range

--
Mr

Zer -----------------------------------------------------------------------

Mr Zero's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=1558 View this
thread: http://www.excelforum.com/showthread.php?threadid=27724

Hi Mr. Zero,

I handled a yearly summary sheet by having the totals on the same cell in
each worksheet. Then I totalled all the worksheets for the year in the
summary sheet. Even the months that haven't occurred effectively have a
space reserved when the number comes in. I have only done this within a
workbook but I'm sure the concept can be used between workbooks too.

bye

Darlene