View Single Post
  #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