software

I have a sub total in my spreadsheet. I do a sub total at each change of
statement. In each subtotal i have quot;statement 1 totalquot;, quot;statement 2 total',
etc. My next column is account number which corresponds to one statement,
i.e. statement 1 is always account 1000, etc.

I copied and paste the subtotals in another spreadsheet and so I lost the
account number. Is there a way to resolve this.

thanks.
del

You may have better results if you use a pivot table, instead of subtotals.

There are pivot table instructions in Excel's Help, and Jon Peltier has
instructions and links:

www.peltiertech.com/Excel/Pivots/pivotstart.htmarcticale wrote:
gt; I have a sub total in my spreadsheet. I do a sub total at each change of
gt; statement. In each subtotal i have quot;statement 1 totalquot;, quot;statement 2 total',
gt; etc. My next column is account number which corresponds to one statement,
gt; i.e. statement 1 is always account 1000, etc.
gt;
gt; I copied and paste the subtotals in another spreadsheet and so I lost the
gt; account number. Is there a way to resolve this.
gt;
gt; thanks.
gt; del--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html