using subtotals with other data to calculate

[Doug Mulkey]

I need help!! I'm trying to use the subtotals of one
worksheet to paste into another to calculate out costs but
when I paste them over, I get all of the cells including
the subtotals. I only want the subtotals & to be able to
match them to another group of data for calculations. Can
anyone help me?

Doug

 

[Debra Dalgleish]

To copy just the subtotal amounts:

1. Collapse the Subtotals, and select the range of cells that
you want to copy.
2. Choose Edit>Go To, click Special
3. Select Visible cells only, click OK
4. Choose Edit> Copy
5. Select the cell where the paste should start
6. Choose Edit>Paste

 

[Dave Peterson]

You're selecting the cells when you already have hidden some of the rows?

After you've selected the range, hit F5 (edit|goto, or Ctrl-G),
then click special
then Visible cells only
Then copy those cells/rows.
and paste.

You may want to dump the Data|subtotal and look at Data|pivottable. If you use
the subtotals in another step, then this might change your whole world.

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

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