The boss has a Excel file that has 20 to 40 sheets depending on the work
load. One sheet is named "totals" . All the other sheets have unique
names that have the total for that sheet in F32. The totals sheet has
=sum in F32 that sums all the sheets in the workbook. When sheets are
added or deleted it is a manual process. Any ideas on automating this
process to get totals?


--
czywrg
------------------------------------------------------------------------
czywrg's Profile: http://www.excelforum.com/member.php...o&userid=31051
View this thread: http://www.excelforum.com/showthread...hreadid=537297

The best way would be to have a hidden sheet called "Start" that
comes before your data worksheets and another hidden sheet called
"End" that comes after all your data worksheets. Then use the
formula

=SUM(Start:End!F32)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"czywrg"
wrote in message
...

The boss has a Excel file that has 20 to 40 sheets depending on
the work
load. One sheet is named "totals" . All the other sheets have
unique
names that have the total for that sheet in F32. The totals
sheet has
=sum in F32 that sums all the sheets in the workbook. When
sheets are
added or deleted it is a manual process. Any ideas on
automating this
process to get totals?


--
czywrg
------------------------------------------------------------------------
czywrg's Profile:
http://www.excelforum.com/member.php...o&userid=31051
View this thread:
http://www.excelforum.com/showthread...hreadid=537297

one way:

Create two blank sheets, named, say, First and Last, with First on the
left and Last on the right. Place all the sheets to be totaled between
them.

Then use

=SUM(First:Last!F32)

In article ,
czywrg wrote:

The boss has a Excel file that has 20 to 40 sheets depending on the work
load. One sheet is named "totals" . All the other sheets have unique
names that have the total for that sheet in F32. The totals sheet has
=sum in F32 that sums all the sheets in the workbook. When sheets are
added or deleted it is a manual process. Any ideas on automating this
process to get totals?

Thanks for the great replies! Chip must have worked with my boss
because he will find a way to mess it up. The hidden sheets are very
good ideas.


--
czywrg
------------------------------------------------------------------------
czywrg's Profile: http://www.excelforum.com/member.php...o&userid=31051
View this thread: http://www.excelforum.com/showthread...hreadid=537297