I have used excel to create a workbook where the topsheet is named total and
the sheets below are presently named Property 1, Property 2, Property 3,
Property 4. Each sheet looks exactly like the others. For example cell C1
of each sheet is equal to the property value. I would like to have Excel
sum up all the property values in C1 of all sheets and display it in the
"Total" sheet's C1 cell. I would also like to be able to add new sheets
below the top sheet as I buy more properties, without changing any of the
formulas in the top sheet. Can anyone help me with this. I certainly would
appreciate it.

Hi
see your post in public.excel

--
Regards
Frank Kabel
Frankfurt, Germany


netnews.comcast.net wrote:
I have used excel to create a workbook where the topsheet is named
total and the sheets below are presently named Property 1, Property
2, Property 3, Property 4. Each sheet looks exactly like the others.
For example cell C1 of each sheet is equal to the property value. I
would like to have Excel sum up all the property values in C1 of all
sheets and display it in the "Total" sheet's C1 cell. I would also
like to be able to add new sheets below the top sheet as I buy more
properties, without changing any of the formulas in the top sheet.
Can anyone help me with this. I certainly would appreciate it.