Inserting Multiple Worksheets?

M

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
 
G

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
 
G

Gord Dibben

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

Makes Excel life so much easier.

Gord Dibben Excel MVP
 
D

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.
Click to expand...
=AVERAGE('11-04-04:11-10-04'!C3). Is there
a way to automaticall
Click to expand...
update this range every time another worksheet is added
to the end o
Click to expand...
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
Click to expand...

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
 
Top