Need help with subtotals

I have a spreadsheet of invoices and the items that are on the invoice
I sort by invoice number
and subtotal by invocie
which gives me a total of each invoice - invoice number and total on
same line

what I want to do is copy the list of invoice numbers and their totals
to a new spreadsheet - the problem is when I do this the items on the
invoice copy over as well.

What can I do?

Assuming the table is collapsed to suit
Select the range
Press F5 > Special > Visible cells only > OK
Right-click on the selection > Copy
Then just go to the new sheet > paste
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"yahoo" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet of invoices and the items that are on the invoice
> I sort by invoice number
> and subtotal by invocie
> which gives me a total of each invoice - invoice number and total on
> same line
>
> what I want to do is copy the list of invoice numbers and their totals
> to a new spreadsheet - the problem is when I do this the items on the
> invoice copy over as well.
>
> What can I do?