#1   Report Post  
Dave o
 
Posts: n/a
Default subtotals copying

i would like to know an easy way to copy the subtotals - from using the
subtotals function - into a new worksheet.
You cannot just copy the page because the copy then includes all of the
individual lines that you want subtotaled.
Currently, the only way i know how to is to hold down the Control key and
click each (subtotaled) individual line.
This is rough when i have several thousand subtotals to copy.

thanks
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Apply your data|subtotals
Use the outline symbols to just show what you want
select that range
edit|goto|special|check visible cells only

now do copy|paste



Dave o wrote:

i would like to know an easy way to copy the subtotals - from using the
subtotals function - into a new worksheet.
You cannot just copy the page because the copy then includes all of the
individual lines that you want subtotaled.
Currently, the only way i know how to is to hold down the Control key and
click each (subtotaled) individual line.
This is rough when i have several thousand subtotals to copy.

thanks


--

Dave Peterson
  #3   Report Post  
Dave o
 
Posts: n/a
Default

This was TOTALLY helpful - this is a setting i have never used beofre - major
thanks!

"Dave Peterson" wrote:

Apply your data|subtotals
Use the outline symbols to just show what you want
select that range
edit|goto|special|check visible cells only

now do copy|paste



Dave o wrote:

i would like to know an easy way to copy the subtotals - from using the
subtotals function - into a new worksheet.
You cannot just copy the page because the copy then includes all of the
individual lines that you want subtotaled.
Currently, the only way i know how to is to hold down the Control key and
click each (subtotaled) individual line.
This is rough when i have several thousand subtotals to copy.

thanks


--

Dave Peterson

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

There are lots of neat options under that Edit|goto|special dialog.

Dave o wrote:

This was TOTALLY helpful - this is a setting i have never used beofre - major
thanks!

"Dave Peterson" wrote:

Apply your data|subtotals
Use the outline symbols to just show what you want
select that range
edit|goto|special|check visible cells only

now do copy|paste



Dave o wrote:

i would like to know an easy way to copy the subtotals - from using the
subtotals function - into a new worksheet.
You cannot just copy the page because the copy then includes all of the
individual lines that you want subtotaled.
Currently, the only way i know how to is to hold down the Control key and
click each (subtotaled) individual line.
This is rough when i have several thousand subtotals to copy.

thanks


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy subtotals from excel without it also copying the det slh Excel Discussion (Misc queries) 2 March 1st 07 12:22 AM
copying subtotals in Pivot tables Tab Excel Worksheet Functions 3 June 23rd 05 09:11 PM
How do I copy an outline w/ subtotals & paste just the subtotals av Excel Discussion (Misc queries) 1 June 20th 05 11:35 PM
Copying subtotals in Excel 2000 pearsall Excel Discussion (Misc queries) 3 April 21st 05 01:05 PM
Copying Subtotals? Robin Funnell Excel Discussion (Misc queries) 4 February 13th 05 02:33 AM


All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"