subtotalling

  • Thread starter Thread starter Carlo
  • Start date Start date
C

Carlo

Hi
Is there a way when using the subtotalling function, to then copy and
paste just the subtotals to another sheet, without picking up all the
detail lines (even if you click on the summary sheet and then try copy
and paste it picks up the detail)
Thanks
Carlob1
 
Carlo,

Go to menu Edit>GoTo
Click the Special... button
Select the Visible Cells radio button
Exit out

Copy the selected cells

Go to menu Edit>PasteSpecial
Click the Values radio button
Exit out.

That should do it for you
 
Collapse the data, select what you want, do Edit / Go To / Special / Visible cells only, then copy
and paste where you want.
 
I dont know how to do that specifically, but you could
name the range (lets say "temp") that is inclusive of the
subtotals. Lets say your first category is "one." You
could then do a vlookup on your named range "temp" for the
value associated with the name "one Total."
You'll just need to make a list of your category titles
where you want your results to be.
So...

1. Highlight full range of subtotals area and give a name
under...insert/name/define. [I'll use "temp"]

2. Make list of Category Names vertically where you'd like
your subtotal values to be located. [i'll use list
starting in cell a1]

3. enter this formula in cell b1 and copy down to bottom
of your category list. =vlookup(a1&" Total",temp,2,0)

Note: The 2 in the vlookup formula refers to the column
number of your total data, if you have more columns, than
change appropriately.


hth,
Dave



3. enter this formula to the right of
 
Back
Top