software

I have multilple worksheets that use the same format to keep track of
additions and retirements to plant records. However there is only an
entry for each year that has activity. The form has a running sum on
each sheet in colum I.
I need to have a summary sheet that keeps track of all running sum
totals each year. So for instance, in 2005, I would need to know the
balance of each sheet with entries for 2005.

Example:
Sheet 1 2005 balance is in cell I30
Sheet 2 2005 balance is in cell I10
Sheet 3 2005 balance is in cell I1

Being the cell number can change from sheet to sheet, I don't know how
to make a summary sheet giving me the totals I need since you never
know which cell it is in. I have some workbooks that have 50
worksheets in them so I don't want to have to go to each page and find
the sum.

Sorry if I didn't explain this well...Not a real whiz!
Thanks for any help or suggestions you can provide.--
karstens
------------------------------------------------------------------------
karstens's Profile: www.excelforum.com/member.php...oamp;userid=17657
View this thread: www.excelforum.com/showthread...hreadid=525005What you want is fairly easy for Excel to do in VBA. But Excel will need to
know from which sheets to get the data. Using your example of wanting to
create a summary of all the 2005 sheets, how can Excel tell that some sheet
is or isn't a 2005 sheet? Does the sheet name contain quot;2005quot;? If so, give
us some examples of the sheet names.
Or maybe there is something in some cell of each sheet that indicates
what year that sheet applies to? Post back with more details of what you
have. HTH Otto
quot;karstensquot; gt; wrote in
message ...
gt;
gt; I have multilple worksheets that use the same format to keep track of
gt; additions and retirements to plant records. However there is only an
gt; entry for each year that has activity. The form has a running sum on
gt; each sheet in colum I.
gt; I need to have a summary sheet that keeps track of all running sum
gt; totals each year. So for instance, in 2005, I would need to know the
gt; balance of each sheet with entries for 2005.
gt;
gt; Example:
gt; Sheet 1 2005 balance is in cell I30
gt; Sheet 2 2005 balance is in cell I10
gt; Sheet 3 2005 balance is in cell I1
gt;
gt; Being the cell number can change from sheet to sheet, I don't know how
gt; to make a summary sheet giving me the totals I need since you never
gt; know which cell it is in. I have some workbooks that have 50
gt; worksheets in them so I don't want to have to go to each page and find
gt; the sum.
gt;
gt; Sorry if I didn't explain this well...Not a real whiz!
gt; Thanks for any help or suggestions you can provide.
gt;
gt;
gt; --
gt; karstens
gt; ------------------------------------------------------------------------
gt; karstens's Profile:
gt; www.excelforum.com/member.php...oamp;userid=17657
gt; View this thread: www.excelforum.com/showthread...hreadid=525005
gt;

Thanks for your quick reply!

In one workbook, some of the sheet names are as follows:

General Office
Pole Yard
St George
Courtland
Klossner
Searles

Each sheet uses the same fomat...but here is the information from one
of the sheets (General Office):

_Year_ _Description_ _Additions_ __Retirements_
_Balance_

Row 7...Year:9/30/79 Decscription:Additions to Date Additions: 0
Retirements 0 Balance 20394.90Row 8...Year:12/31/91 Decscription:Added Sewer Additions: 10587.97
Retirements 0 Balance 30982.87

This example does not have anything for 2005 but still gives you the
data I am working with.

My summary sheet should have the same columns, just should give a total
of all the worksheets. So in this example, I should have a line that
would result in:
1991......Additions are 10587.97 (plus any other worksheets with
additions in 91)...Retirements 0 (plus any other worksheets with
retirements in 91), balance of 30982.87 (Plus the balance of other
worksheets with activity in 91).

I know I am not explaining this well and I apologize. If this is not
explanitory enough, please let me know. Thanks again....I appreciate
your help.--
karstens
------------------------------------------------------------------------
karstens's Profile: www.excelforum.com/member.php...oamp;userid=17657
View this thread: www.excelforum.com/showthread...hreadid=525005Let me see if I understand what you have. In each sheet you have a date and
other information in each row. The years of the dates are NOT the same for
all rows. Do you want to sum the balances for Additions, Retirement as
well, not just Column I? But from what you say, the last row does not have
the balances for any particular year. Rather, it has the balance for all
the years that are on that sheet. Is that correct?
Is it that you want to sum up all the values in those rows that have a
date with a particular year?
This is more complicated than you can explain. If you wish, make up and
send me, via email, a small file with a handful of sheets and include a few
dozen rows of your data in each sheet in the same layout as your actual
file. Include the summary sheet that you want and include a couple of
examples in the summary sheet to show me what you want. Clearly show and/or
explain from where you got the data that you show in the summary sheet. My
email address is . Remove the quot;nopquot; from this address.
Otto

quot;karstensquot; gt; wrote in
message ...
gt;
gt; Thanks for your quick reply!
gt;
gt; In one workbook, some of the sheet names are as follows:
gt;
gt; General Office
gt; Pole Yard
gt; St George
gt; Courtland
gt; Klossner
gt; Searles
gt;
gt; Each sheet uses the same fomat...but here is the information from one
gt; of the sheets (General Office):
gt;
gt; _Year_ _Description_ _Additions_ __Retirements_
gt; _Balance_
gt;
gt; Row 7...Year:9/30/79 Decscription:Additions to Date Additions: 0
gt; Retirements 0 Balance 20394.90
gt;
gt;
gt; Row 8...Year:12/31/91 Decscription:Added Sewer Additions: 10587.97
gt; Retirements 0 Balance 30982.87
gt;
gt; This example does not have anything for 2005 but still gives you the
gt; data I am working with.
gt;
gt; My summary sheet should have the same columns, just should give a total
gt; of all the worksheets. So in this example, I should have a line that
gt; would result in:
gt; 1991......Additions are 10587.97 (plus any other worksheets with
gt; additions in 91)...Retirements 0 (plus any other worksheets with
gt; retirements in 91), balance of 30982.87 (Plus the balance of other
gt; worksheets with activity in 91).
gt;
gt; I know I am not explaining this well and I apologize. If this is not
gt; explanitory enough, please let me know. Thanks again....I appreciate
gt; your help.
gt;
gt;
gt; --
gt; karstens
gt; ------------------------------------------------------------------------
gt; karstens's Profile:
gt; www.excelforum.com/member.php...oamp;userid=17657
gt; View this thread: www.excelforum.com/showthread...hreadid=525005
gt;

Thank you....I have sent the file via email. Let me know if it comes
through ok. Thanks again!--
karstens
------------------------------------------------------------------------
karstens's Profile: www.excelforum.com/member.php...oamp;userid=17657
View this thread: www.excelforum.com/showthread...hreadid=525005