Inserting Multiple Worksheets?

  • Thread starter Thread starter Mr Zero
  • Start date Start date
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
 
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
 
Too bad you won't learn how to use code.

Makes Excel life so much easier.

Gord Dibben Excel MVP
 
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
 
Back
Top