how do i copy subtotals without the underlying data?

H

Homer

Hi

I want to copy the subtotals only from one sheet to another, there must be a
way??

Thanks

Homer "D'oh"
 
J

JulieD

Hi Homer

display only the subtotals on the screen and click on one of them
choose edit / goto, click the Special button
select
visible cells only
click OK

now COPY and PASTE as usual.
 
G

Guest

Hi
Reduce the grouping to show just the information you want. Hit F5 and select
Visible Cells.
Ctrl+C to copy. Move to where you want the totals and click Edit / Paste
Special / Values.
 
R

RagDyeR

If you do this often, you may wish to place the icon on your toolbar.

Right click in the toolbar and choose "Customize", then <Commands> tab,

Click <Edit> in the left window, and scroll down to the next to last item in
the right window.

Click and drag it to your toolbar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi

I want to copy the subtotals only from one sheet to another, there must be a
way??

Thanks

Homer "D'oh"
 
H

Homer

Thanks JulieD and AndyB thats done it!

JulieD said:
Hi Homer

display only the subtotals on the screen and click on one of them
choose edit / goto, click the Special button
select
visible cells only
click OK

now COPY and PASTE as usual.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
Click to expand...
 
Top