Re: Sub-Totals to Summary?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: OZDOC1050 (peteryoungNOSPAM_at_iprimus.com.au)
Date: 12/30/04

Next message: aaron_kempf_at_hotmail.com: "Re: WHY"
Previous message: Frank Kabel: "Re: Protect Code"
In reply to: Dan: "Sub-Totals to Summary?"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 31 Dec 2004 02:12:49 +0930

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

-- 
(][ This Email has been scanned by Norton AntiVirus. ][)
"Dan" <dan@nospam..com> wrote in message 
news:e7Fx9qo7EHA.824@TK2MSFTNGP11.phx.gbl...
> 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 work*** without the supporting details.  When I Paste Special 
> it Excel still includes the data that was sub-totaled. Can someone help 
> me?
>
> TIA,
> Dan

Next message: aaron_kempf_at_hotmail.com: "Re: WHY"
Previous message: Frank Kabel: "Re: Protect Code"
In reply to: Dan: "Sub-Totals to Summary?"
Messages sorted by: [ date ] [ thread ]