Sub-Totals to Summary?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi,

I am trying to summarize row data by a field. I sub-total then I
collapse the the outline to get my summary. But then I want to copy
this summary to a new worksheet without the supporting details. When I
Paste Special it Excel still includes the data that was sub-totaled.
Can someone help me?

TIA,
Dan
 
Have you copied " Visible Cells Only " ?

before copy go to << EDIT > GO TO > SPECIAL > VISIBLE CELLS ONLY >>

This should help and you can add it to a macro if you want, something like

Range("B17:Z609").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy

then your paste special here

regards
Pete
 
Back
Top