Copying Only Sub-totals to another Location

[ringo tan]

Hi,
How can I copy 'only' the sub-totals of a database to another location,
ignoring the transactions before the respective sub-total?

Sales Department:
transaction A 1000
transaction B 2000
transaction C 3000
---------------------------------
sub total 6000

Material Department:
transaction D 2000
transaction E 2000
transaction F 2000
transaction G 2000
---------------------------------
sub total 8000


**To copy below-mentioned information to another worksheet,
Sales Department:
sub total 6000
Material Department
sub total 8000
GRAND TOTAL 14000


Thanks and Regards,
Ringo

 

[RagDyer]

You could try this:

Collapse the detail, where only the subtotals are displayed.
Then, select the visible cells that you wish to copy and:
<F5>, click "Special", check "VisibleCellsOnly", then <OK>.

Right click in this selection, and choose "Copy".
Navigate to the top left cell where you wish to start pasting, making sure
that this location does not include any of the rows that might be masked by
the subtotal collapse, and hit <Enter>.
--

HTH,

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


Hi,
How can I copy 'only' the sub-totals of a database to another location,
ignoring the transactions before the respective sub-total?

Sales Department:
transaction A 1000
transaction B 2000
transaction C 3000
---------------------------------
sub total 6000

Material Department:
transaction D 2000
transaction E 2000
transaction F 2000
transaction G 2000
---------------------------------
sub total 8000


**To copy below-mentioned information to another worksheet,
Sales Department:
sub total 6000
Material Department
sub total 8000
GRAND TOTAL 14000


Thanks and Regards,
Ringo