copy subtotals

[lparsons]

Hi: I was able to copy the subtotals to another area using the
*total. It worked great. However the cust numbers that correspond to
the subtotals are not showing. Since this file has over 10,000 lines
manually copying the cust# would be a real drag. When you do the
subtotals function in Excel it only shows the numbers on the line and
not any of the names. Am I missing something?? I would appreciate
any help..

Thanks in advance
Lois

ex:
cust1
custi
cust1
totals only
cust2
cust2
totals only

 

[Dave Peterson]

If you're only interested in subtotals, take a look at Data|Pivottable.

After about an hour of learning, you'll wonder how you ever lived without it.

Here are some links for pivottable info:

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx