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.