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

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

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

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